SQL Anywhere Mobile - BD grows a lot

Author

BD grows a lot

OMTECH

2005-08-16, 1:27 pm

When I synchronize the first time the size of the BD 12 MB,
after some synchronizations (download and upload) the size
of the BD is 18 MB.

Why does that happen if the quantity of records that I
donwload the same one is?. Besides the great size of the
BD, the file is. log and the log_old, all this sum more
than 30 MB and therefore my pocket every time it keeps less
memory and it causes me problems in the synchronization.
What can I make to solve this?

David Fishburn

2005-08-16, 8:24 pm

OMTECH wrote in news:430206ca.2608.1681692777@sybase.com
of sybase.public.sqlanywhere.mobilink:

O> When I synchronize the first time the size of the BD 12 MB,
O> after some synchronizations (download and upload) the size
O> of the BD is 18 MB.
O> Why does that happen if the quantity of records that I
O> donwload the same one is?.
O>

Space has to be made available to "rollback" a failed synchronization.
So you need the original space + space for the new stuff + space to
rollback just in case something bad happens.

....
O> Besides the great size of the
O> BD, the file is. log and the log_old, all this sum more
O> than 30 MB and therefore my pocket every time it keeps less
O> memory and it causes me problems in the synchronization.
O> What can I make to solve this?

Please read up on:
SQL Remote User's Guide
Administering SQL Remote for Adaptive Server Anywhere
Transaction log and backup management
Managing old transaction logs

Those instructions are relevant to either dbremote or dbmlsync.
That will take care of your log file growth.

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]

Sponsored Links