on 2020 May 09 3:07 PM
I know that in Microsoft Access there is a mechanism called Repair Database, which as result optimizes the performance and the size of the database.
Is there any similar mechanism in SQL Anywhere?
We have currently problems of database size (some gigabytes), and we know that the actual data is not that big, but the most of size is 'debris' remaining from INSERT and DELETE
In many cases, space that has been used in the database and freed will get reused. If that is not the case in your environment (the growth is an one-time event), rebuilding the database makes sense. Otherwise, the cost of rebuilding a database that will grow again may not provide much benefit.
There are two approaches to rebuilding a database that is involved in replication or synchronization.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can use dbinfo or various system procedures to check for free pages, and you can use reorganize table for a running database or a complete reload to minimize size. There are many FAQ here related to this topic.
Aside: Having used MS Access as a database in former times, I would really refrain from comparing it and its "repair mode" to a "real" database system like SQL Anywhere...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes. That's the only way to reduce the database size.
User | Count |
---|---|
71 | |
11 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.