Do you also have the impression that our computers are not really faster than several years ago? Yes, their clock speed is much higher than in the last century, we have now up to 250 times more memory than 20 years ago, great! But you know what; the massive advances in technology in the past two decades have brought zero advances in productivity. Amazing, isn't it? Check out the comparison here.
Let's take a look at Topobase. How can you improve the performance of your Topobase installation and increase your productivity? We are continuously testing the performance inside engineering and finding new optimizations, not only in the software but also in the configuration. I would like to share some insights in some of the next blog posts. Let's begin with a simple one.
Start optimizing your Oracle database with a single click! We recommend that you run the Optimize command whenever you have extensive changes to the data, such as imports or major updates.
To optimize:
Start the Topobase Administrator and open your workspace.
Click the Data Model node. This opens the Data Model Administrator.
Right-click on the root item in the tree view and click Optimization -> Optimize Topobase schema.
That's it!
This function gathers the statistics for the whole database schema with the Oracle function DBMS_STATS.GATHER_SCHEMA_STATS. These statistics are important for the Oracle optimizer to generate optimal execution plans.
Comments