SQL Anywhere Mobile - Low performance for Mobilink-Download

Author

Low performance for Mobilink-Download

Johannes

2005-10-31, 3:24 am

Hello group,

We've noticed that our Mobilink connection is very slow when
most of the data in a session is in blob fields. We're
using Moblilink with DSL and Checkpoint-VPN (Edge Box X8).
A recent test resulted in Mobilink needing one hour and 20
minutes to transfer a data volume of 23 MB. Downloading the
same volume using a http protocol needed only four minutes
and 12 seconds. What can we do to get Mobilink transfers
speeded up?

Server: 9.0.2.3182 ASA Database & Mobilink
Client: 9.0.2.3182 ASA Database & Mobilink

Thanks in advance,
Regards
Johannes

Graham Hurst

2005-10-31, 11:24 am

There are 3 phases to the download with MobiLink:

1. Fetching the data from the consolidated to the MobiLink server.
Basically this is the time taken to run the download_cursor. If there
are other synchronizations or non-sync connections to the database then
one has to be careful to avoid contention. Also, make sure that each
synced table has an index that matches the WHERE clause.

2. Transferring the download stream from the ML server to the remote
database. This time should be similar to the time taken to transfer a
file of the same size outside of MobiLink but using the same protocol.

Were you using HTTP stream with MobiLink? In general TCP/IP is much
faster. If you have to use HTTP, then you'll get the best performance by
making the buffer_size stream parameter large enough to hold the whole
upload or download.

(BTW I'm not sure what you mean by "downloading using an http protocol".
Did you have an HTML page that size? Was it going through same VPN and
firewall?)

3. Applying the download stream to the remote database.

You need to try to determine which of the above are taking so long. For
most customers #1 is the bottleneck. Using -vcns for the ML server and
looking at the times in the log should help determine where the
bottleneck is.

Cheers,

Graham

Johannes wrote:
> Hello group,
>
> We've noticed that our Mobilink connection is very slow when
> most of the data in a session is in blob fields. We're
> using Moblilink with DSL and Checkpoint-VPN (Edge Box X8).
> A recent test resulted in Mobilink needing one hour and 20
> minutes to transfer a data volume of 23 MB. Downloading the
> same volume using a http protocol needed only four minutes
> and 12 seconds. What can we do to get Mobilink transfers
> speeded up?
>
> Server: 9.0.2.3182 ASA Database & Mobilink
> Client: 9.0.2.3182 ASA Database & Mobilink
>
> Thanks in advance,
> Regards
> Johannes

Reg Domaratzki \(iAnywhere Solutions\)

2005-10-31, 1:23 pm

If you move your remotes databases to the same network where the MobiLink
server is running, do you still notice the same speed difference in
synchronization times between TCP/IP and HTTP synchronizations? I'm just
trying to narrow down whether the problem is with the MobiLink protocol or
whether it's the VPN piece in the middle that is causing the slow down.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"

<Johannes> wrote in message news:4365dc6e.51fd.1681692777@sybase.com...
> Hello group,
>
> We've noticed that our Mobilink connection is very slow when
> most of the data in a session is in blob fields. We're
> using Moblilink with DSL and Checkpoint-VPN (Edge Box X8).
> A recent test resulted in Mobilink needing one hour and 20
> minutes to transfer a data volume of 23 MB. Downloading the
> same volume using a http protocol needed only four minutes
> and 12 seconds. What can we do to get Mobilink transfers
> speeded up?
>
> Server: 9.0.2.3182 ASA Database & Mobilink
> Client: 9.0.2.3182 ASA Database & Mobilink
>
> Thanks in advance,
> Regards
> Johannes

Johannes

2005-11-04, 3:24 am

Hi,

No, on the same network where the ML server is running are
the speed difference in synchronisation times between TCP/IP
and HTTP circa the same.

Regards
Johannes

> If you move your remotes databases to the same network
> where the MobiLink server is running, do you still notice
> the same speed difference in synchronization times between
> TCP/IP and HTTP synchronizations? I'm just trying to
> narrow down whether the problem is with the MobiLink
> protocol or whether it's the VPN piece in the middle that
> is causing the slow down.
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer
> Version 8 Please reply only to the newsgroup
>
> iAnywhere Developer Community :
> http://www.ianywhere.com/developer iAnywhere Documentation
> : http://www.ianywhere.com/developer/product_manuals ASA
> Patches and EBFs :
> http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set filter to "Display ALL platforms IN ALL MONTHS"
>
>
> <Johannes> wrote in message
>
>

Johannes

2005-11-04, 7:24 am

Sponsored Links