Any specific operation on 250,000 rows will now take 26 seconds as opposed to over 2 hours in version 11.0.
All operations including inserting, updating, deleting, cloning, erasing changes, pasting and SQL previews have been optimized for large datasets. Using the Table Data Editor for bulk operations is a much more pleasant experience with the speed increases achieved in version 12.0. These bulk operations are then converted to SQL which can be thousands of statements.
AQUA DATA STUDIO WIKI V12 UPDATE
The Table Data Editor is a popular feature for data entry by many users since it provides Excel like features for bulk operations to insert, update and delete data. Performing a compare between two 250,000 resultsets now takes 18 seconds instead of 4+ hours! With our optimized compare algorithm, response times now scale linearly instead of polynomially as happened in version 11.0. Once you have your large datasets in memory, you may want to compare them using the results compare tool. For instance, executing a query on Oracle that returns 250,000 records now takes 9 seconds instead of 89 seconds!
AQUA DATA STUDIO WIKI V12 CODE
By optimizing our code base and tuning the default JDBC connection options, we have increased data set retrieval for databases up to 1000%. Optimizing data retrieval is a huge productivity boost for users who query for very large datasets on a regular basis. Querying for hundreds of thousands of rows creates user idle time if the data retrieval is slow. Querying and Exporting datasets is the most highly used functionality of any query tool. Desktop and server are connected over a 1Gb shared network. All database servers are on a single Intel Xeon 8-core machine with each server running within its own VMWare instance. Below, we provide example speeds of Aqua Data Studio 64-bit versions 11.0 and 12.0 configured with 2GB of memory running on Ubuntu Desktop 12.04. The speed increases depend on the database vendor you are using and the specifications of your client machine, server machine and network speed and latency.
To illustrate some of the larger improvements, we have provided comparisons of highly used areas of the application between version 11.0 and 12.0 which include: Query Window execution, Export Tool exporting, Table Data Editor edits and sql generation, Large Script execution and Resultset Comparisons. Enhancements are included across the entire application. Aqua Data Studio 12.0 includes impressive performance gains working with large amounts of data using optimized code algorithms and UI components to better use computer resources. With ever growing data sets, users demand faster data retrieval, faster updating of records and faster resultset comparisons.
0 kommentar(er)
