SQL Anywhere Mobile - Reducing Log File size on First Synchronization

Author

Reducing Log File size on First Synchronization

Bob

2005-03-30, 9:42 am

Hi,

I'm using ASA v 9.0.1. In this I'm trying to take a backup
of my database and I'm using the query "BACKUP DATABASE
ABC.db".

My storage space is 128MB and the size of my .db & .log
files are much more than this. I'm using the -u option in
synchronization to delete old logs. This works absolutely
fine. But the problem is that this does not work on FIRST
TIME SYNCHRONIZATION.

The very first time when I synchronize, my log file grows
upto 90MB while my .db file grows upto 60 MB in size. On
Second and subsequent synchronizations, the log file size is
reduced to less than 100 KB. Can this check be done on FIRST
TIME Synchronization? Is it possible to reduce my log file
size to less than 10 MB on first time synchronization? If
yes, what is the option that I have to include?

A quick reply will really be appreciated.

Cheers,
Bob

David Fishburn

2005-03-30, 9:42 am

Bob wrote in news:4222bc1d.351a.1681692777@sybase.com
of sybase.public.sqlanywhere.mobilink:

....
B> The very first time when I synchronize, my log file grows
B> upto 90MB while my .db file grows upto 60 MB in size.

So how much data are you synchronizing the first time? I take it quite
a bit.

B> On Second and subsequent synchronizations, the log file size is
B> reduced to less than 100 KB. Can this check be done on FIRST TIME
B> Synchronization? Is it possible to reduce my log file size to less
B> than 10 MB on first time synchronization? If yes, what is the option
B> that I have to include?

Do 2 syncs in a row the first time.
Once the client confirms to the ML server that the previous sync was
successful, it can rename and delete the large log.

This is the exact behaviour you are seeing, and that is just the way it
works. You are downloading a lot of data, and that data has to be
applied to the remote. That is growing the log (as expected).

--
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