1. Smart City doo
  2. Valentina Server
  3. Sunday, October 06 2019, 09:08 PM
  4.  Subscribe via email
I am executing COMPACT but with no result.

Database has 5.3Gb.

I deleted about 20.000 records and tried to COMPACT, but my database is still 5.3Gb.

Zoran
Comment
There are no comments made yet.
Ruslan Zasukhin Accepted Answer
so, lets again:

COMPACT should work, but it works mostly for case when you have delete a field or the whole table.
i.e. in db there is space from a deleted logical file.

COMPACT does not squeeze of space of deleted records, because Valentina never move records.
Instead, it will reuse that space.

Space of deleted BLOB values can be reused also.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 1
Smart City doo Accepted Answer

3) Do you mean you want Compacting of a db under working VSERVER?
Well, this should be a feature request. We ware going do something similar.

This would be fine.


4) I wonder why you think this is a required step?
After deleting 20K records, I think users will start to add new records and they will automatically reuse that empty space.


You are right.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 2
Ruslan Zasukhin Accepted Answer
Hi,
1) if that records did not contain BLOB values, then compact can do nothing.

As far as I remember compact() do not try to move records of a Table into deleted places.
But it does this for BLOB fields (deleted values) AND for deleted internal logical files, e.g. after DELETE some column, index or table.


2) If you have to delete N records in a Table, then you really should use Clone() to get totally "clean"
Clone() do the additional job, moving records, it builds special maps of changed RecIDs, etc.


3) Do you mean you want Compacting of a db under working VSERVER?
Well, this should be a feature request. We ware going do something similar.

4) I wonder why you think this is a required step?
After deleting 20K records, I think users will start to add new records and they will automatically reuse that empty space.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 3
Smart City doo Accepted Answer
Any news about compacting of database in vServer?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 4
Smart City doo Accepted Answer
We should check it, but as a workaround you may try to Clone the database.

This is not usefull for me.
I need compacting of database in working production.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 5
Ivan Smahin Accepted Answer
We should check it, but as a workaround you may try to Clone the database.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 6
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories