SQL Anywhere ultralite - Ultralite File Size (UDB)

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Ultralite File Size (UDB)

Jobson Martins

2006-02-15, 1:23 pm

VERSION: Ultralite for AppForge, 9.0.2.3044

Hi,

I'm having a problema apparently related to database file
fragmentation. The UDB file is growing significantly even with data
history control. We think this is related to database fragmentation.
For example, a "real life" UDB file with 6 MB was reduced to 4,5 MB
after resync from start (initial sync). The actual data in the two
files was the same, the only difference being that the second one was
populated through a full initial synchronization.

Does Ultralite have anything to deal with this UDB file growth? Is
there anything that can be done to reduce this kind of problem?

I appreciate any help.

Thanks a lot,

Jobson

Sponsored Links