1. Smart City doo
  2. Valentina Server
  3. 日, 10月 06 2019, 09:08 PM
  4.  メールで購読
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
コメント
There are no comments made yet.
Ivan Smahin 承諾済みの回答
We should check it, but as a workaround you may try to Clone the database.
コメント
There are no comments made yet.
Smart City doo 承諾済みの回答
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.
コメント
There are no comments made yet.
Smart City doo 承諾済みの回答
Any news about compacting of database in vServer?
コメント
There are no comments made yet.
Ruslan Zasukhin 承諾済みの回答
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.
コメント
There are no comments made yet.
Smart City doo 承諾済みの回答

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.
コメント
There are no comments made yet.
Ruslan Zasukhin 承諾済みの回答
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.
コメント
There are no comments made yet.
  • ページ :
  • 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. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories