Performance Specification
Data Studio's performance to load and operate on the object browser directly depends on the number of objects to be loaded. These include tables, views, columns and so on.
The memory consumption also depends on the number of objects loaded.
To improve the performance of loading objects and of memory usage efficiency, it is recommended to split the objects across multiple namespaces and avoid having skewed namespaces with a very large number of objects. By default, Data Studio loads the namespaces in the search_path set for the user logged in. Other namespaces and the contained objects are loaded only when needed.
To improve performance load all objects rather than loading them based on user privilege. Minimum Privileges Requirement table provides information on the minimum access required for objects to be listed in Object Browser.
| Object Type | Privilege Types | Object Browser - Minimum Privilege Type |
|---|---|---|
| Database | Create, Connect, Temporary/Temp, All | Connect |
| Schema | Create, Usage, All | Usage |
| Table | Select, Insert, Update, Delete, Truncate, References, All | Select |
| Column | Select, Insert, Update, References, All | Select |
| View | Select, Insert, Update, Delete, Truncate, References, All | Select |
| Sequences | Usage, Select, Update, All | Usage |
| Function | Execute, All | Execute |
| Tablespace | Create, All | Create |
To improve performance of Find/Find and Replace operation, it is recommended to split lines that have more than 10000 characters in a single line into multiple smaller lines.
The following observations and outcomes of the performance tests will help understand the performance aspects of Data Studio more clearly:
| Recommended maximum memory that can be configured (Current release version) | 1.4 GB | |
| Performance with 150 KB tables and 150 KB views with 3 columns each at maximum memory configuration: | ||
| > | Time taken to refresh the namespace in the object browser | 15s |
| > | Time taken for initial loading and expanding of all tables/views in the object browser | 90s-120s |
| > | Time taken for subsequent loading and expanding of all tables/views in the object browser | <10s |
| > | Total Memory occupied | 700 MB |
This representative performance data is included for reference only. Actual performance may vary depending on the usage scenarios.
Last Article: Security
Next Article: Security Management
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.