SQL Anywhere Mobile - Synchronization is very slow

Author

Synchronization is very slow

Bob

2005-11-11, 1:24 pm

Hi,
We are using the ASA 9.0.1.1899 with oracle 9i as
consolidated db. Now we are facing that synchronization
process is taking so much of time. We are created the index
for all Columns in the server which we are using it as the
conditional columns. Will it help us if we do the same thing
in the client side too. if yes on which columns we need to
do that. since we are not writting any query in the client
side. ( is it for all modified datetime column). Pls tell me
some suggestion to increase the speed( I hope our network is
pretty fast. I need to anything on ourside i.e. in the
database side to do to increase the performance.
Hope for the reply.
regards,
Bob

Greg Fenton

2005-11-11, 8:24 pm

Bob wrote:
> We are created the index
> for all Columns in the server which we are using it as the
> conditional columns. Will it help us if we do the same thing
> in the client side too.

This question is more appropriate to the General newsgroup.

Creating indexes you describe in the remote *might* improve
performance...but why not let the database tools tell you which indexes
to create? Consider trying the Index Consultant on a captured workload
(start the IC on a running database, run your app for a while, stop the
IC capture and do that analysis).

> if yes on which columns we need to
> do that.

The Index Consultant will look at your schema, the data within the
database and the requirements of the queries it sees and from that it
will suggest indexes you should add (or drop) from your database for
optimal responses from your queries.

> Pls tell me
> some suggestion to increase the speed( I hope our network is
> pretty fast. I need to anything on ourside i.e. in the
> database side to do to increase the performance.

Though creation of indexes is often the Big Win when it comes to
performance and tuning, the *first* thing you need to do is to isolate
the root cause of your performance problems. Having indexes on every
column in the database won't improve performance if you are dealing with
locking issues.

All of this is outlined in the P&T sections of the SQLAnywhere
documentation:

ASA SQL User's Guide
Monitoring and Improving Performance
- Top performance tips

and

ASA SQL User's Guide
Working with Database Objects
Working with indexes
- Index Consultant overview

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

James Lim

2005-11-16, 3:24 am

Interesting enough I did encountered the same problem but it's not much
related to the database/index - more towards the setup.

It happened when I turned on the +v switch on mobilink (dbmlsync and
dbmlserv) and it seems like every record it sync-ed across would be logged
to the console. Having to turn it off, it works like a charm... hope it's a
thinker :)

<Bob> wrote in message news:4374e3ee.3b3a.1681692777@sybase.com...
> Hi,
> We are using the ASA 9.0.1.1899 with oracle 9i as
> consolidated db. Now we are facing that synchronization
> process is taking so much of time. We are created the index
> for all Columns in the server which we are using it as the
> conditional columns. Will it help us if we do the same thing
> in the client side too. if yes on which columns we need to
> do that. since we are not writting any query in the client
> side. ( is it for all modified datetime column). Pls tell me
> some suggestion to increase the speed( I hope our network is
> pretty fast. I need to anything on ourside i.e. in the
> database side to do to increase the performance.
> Hope for the reply.
> regards,
> Bob

Sponsored Links