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
Version 8.0 of Aqua Data Studio now includes improved memory optimization methods than previous versions. One of these techniques is a memory compression method for optimizing resultsets which includes redundant data such as numeric data. Quering for large results in data warehousing environments with large quantities of numeric data will yield dramatic memory reductions. Long term use of Aqua Data Studio in these environments will keep memory usage low and in turn keep performance of the application high. The optimizations are most apparent in the Query Analyzer, Query Builder, Saving Results and Exporting of data.
Below are simple examples of a single query on two different types of result sets. One is of redundant numeric and text data, and the other is non-redundant data. The memory optimizations depend on the datasets, but these examples show some relative numbers which can be used to compare optimizations on different datasets.
Queries with large resultsets of "redundant" data in the Grid results required 220% | 455% more memory in previous versions.
| v6.5 | v7.0 | v7.5 | v8.0 | ||
| 189MB / 254MB | 182MB / 254MB | 109MB / 187MB | 34MB / 49MB | ADS Memory Usage | OS Memory Usage by JVM |
Queries with large resultsets of "non-redundant" data in the Grid results required 12% | 64% more memory in previous versions.
| v6.5 | v7.0 | v7.5 | v8.0 | ||
| 173MB / 254MB | 187MB / 254MB | 118MB / 209MB | 105MB / 141MB |
Queries with large resultsets of "redundant" data in the Text and Grid results required 24% | 97% more memory in previous versions.
| v6.5 | v7.0 | v7.5 | v8.0 |
| 140MB / 159MB | 126MB / 224MB | 88MB / 145MB | 71MB / 77MB |
Queries with large resultsets of "non-redundant" data in the Text and Grid results required 17% | 20% more memory in previous versions.
| v6.5 | v7.0 | v7.5 | v8.0 |
| 165MB / 254MB | 203MB / 254MB | 161MB / 205MB | 138MB / 220MB |