New Features - Version 8.0
Memory Optimizations
ER Modeler
New Database Support
    Aster nCluster
    DB2 for z/OS
    Teradata
New Database Version Support
Subversion 1.6 Support
Object Search Tool
Schema Browser
Schema Script Generator
Schema Compare
Visual Editing - Permissions
SQL History/Archive
More Features in ADS 8.0

Memory Optimizations

[All tests were done with Windows 32bit versions of Aqua Data Studio]

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.  Querying 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.

Memory Consumption on Large Results Sets using the Grid Results

Version 8.0 uses less memory than its predecessors on queries with large resultsets of "redundant" data in the Grid results. Older versions require 220% | 455% more memory.

ADS 6.5 Grid Redundant
ADS 7.0 Grid Redundant
ADS 7.5 Grid Redundant
v8.0 Grid Redundant ADS Memory Usage OS Memory Usage by JVM
v6.5 v7.0 v7.5 v8.0 ADS Memory Usage OS Memory Usage by JVM
189MB / 254MB 182MB / 254MB 109MB / 187MB 34MB / 49MB

 

Version 8.0 uses less memory than its predecessors on queries with large resultsets of "non-redundant" data in the Grid results. Older versions require 12% | 64% more memory.

v6.5 Grid non-redundant
v7.0 Grid non-redundant
v7.5 Grid non-redundant
v8.0 Grid non-redundant ADS Memory Usage OS Memory Usage by JVM
v6.5 v7.0 v7.5 v8.0 ADS Memory Usage OS Memory Usage by JVM
173MB / 254MB 187MB / 254MB 118MB / 209MB 105MB / 141MB    

 

Memory Consumption on Large Results Sets using the Text and Grid Results

Version 8.0 uses less memory than its predecessors on queries with large resultsets of "redundant" data in the Text and Grid results. Older versions require 24% | 97% more memory.

ADS 6.5 Text-Grid Redundant
ADS 7.0 Text-Grid Redundant
ADS 7.5 Text-Grid Redundant
ADS 8.0 Text-Grid Redundant ADS Memory Usage OS Memory Usage by JVM
v6.5 v7.0 v7.5 v8.0 ADS Memory Usage OS Memory Usage by JVM
140MB / 159MB 126MB / 224MB 88MB / 145MB 71MB / 77MB    

 

Version 8.0 uses less memory than its predecessors on queries with large resultsets of "non-redundant" data in the Text and Grid results. Older versions require 17% | 20% more memory.

ADS 6.5 Text-Grid Non Redundant
ADS 7.0 Text-Grid Non Redundant
ADS 7.5 Text-Grid Non Redundant
ADS 8.0 Text-Grid Non Redundant ADS Memory Usage OS Memory Usage by JVM
v6.5 v7.0 v7.5 v8.0 ADS Memory Usage OS Memory Usage by JVM
165MB / 254MB 203MB / 254MB 161MB / 205MB 138MB / 220MB