DB bloat?

[Ruslan Zasukhin]

On 12/31/05 11:40 AM, "jda" <jda at his.com> wrote:

> Hi Ruslan,
> 
> One of my beta testers (using my app built with V2.1 fc3) reported this to me:
> 
> "The only stress sign was that by the time I was done, the file had
> bloated from 14 MB to 162 MB! But a final Rebuild set it to proper
> size again."
> 
> (Rebuild is my own export/import of data to a fresh database).
> 
> Any idea why this might have happened? All he was doing was shifting
> data from one field to another, there were no new data added. So lots
> of UpdateRecord and DeleteData for VText/VBlob fields. I will try to
> reproduce it.

Hi Jon,

Only from one field to another ?

He do this copy manually? Or your app have such feature ?

Well, if you delete some BLOB value which is in the middle of BLOB file,
Then its space still live, and will be REUSED future.

So I can see that if you delete one BLOB records and copy them into new BLOB
records this can cause in worse case 2 times grow.

We plan yet that Compact method is able collect such empty space in BLOB
fields.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]