Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
With ever growing data sets, users demand faster data retrieval, faster updating of records and faster resultset comparisons. 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. Enhancements are included across the entire application. 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.
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. 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. All database servers are on a single Intel Xeon 8-core machine with each server running within its own VMWare instance. Desktop and server are connected over a 1Gb shared network.
Querying and Exporting datasets is the most highly used functionality of any query tool. Querying for hundreds of thousands of rows creates user idle time if the data retrieval is slow. Optimizing data retrieval is a huge productivity boost for users who query for very large datasets on a regular basis. By optimizing our code base and tuning the default JDBC connection options, we have increased data set retrieval for databases up to 1000%. For instance, executing a query on Oracle that returns 250,000 records now takes 9 seconds instead of 89 seconds!
Once you have your large datasets in memory, you may want to compare them using the results compare tool. With our optimized compare algorithm, response times now scale linearly instead of polynomially as happened in version 11.0. Performing a compare between two 250,000 resultsets now takes 18 seconds instead of 4+ hours!
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. These bulk operations are then converted to SQL which can be thousands of statements. Using the Table Data Editor for bulk operations is a much more pleasant experience with the speed increases achieved in version 12.0. All operations including inserting, updating, deleting, cloning, erasing changes, pasting and SQL previews have been optimized for large datasets. Any specific operation on 250,000 rows will now take 26 seconds as opposed to over 2 hours in version 11.0.
If you have a large SQL script generated by the Table Data Editor or some other source, you may want to execute the script within the Query Window. To do this, it is recommended that your Text Results are disabled as editors do not perform well with large formatted text. The Grid Results are the best option for working with large datasets. But executing a large script generates many messages which are displayed in the Messages Results which have historically been implemented as formatted text. To better handle working with large scripts, we have redesigned the Message Results to use a Grid of rows which performs much faster and uses much less memory with a large number of messages. Executing a script with 15,000 update statements now only takes 48 seconds vs over 3 minutes in version 11.0 and over a 500% drop in peak memory allocation.
At AquaFold, we strive to make Aqua Data Studio the fastest tool for all your database needs. If you are experiencing any performance bottlenecks on either small or large data sets, email us, and we will put our engineering team to work on tuning your use case. Our engineering team can be reached at [email protected].