Skip to Content
0
Apr 10, 2014 at 08:46 AM

Mobilink max upload

55 Views

SQL Anywhere 12.0.1.3797

Network protocol TCPIP

Speedtest internet (www.speedtest.net) location consolidated: 215 Mbps download, 430 Mbps upload

Size consolidate db 21Gb

Size consolidated log: 58Gb

Start Mobilink: mlsrv12.exe -v -c "DSN=<DSN> Client;UID=DBA;PWD=SQL" -cn 20 -w 10 -wm 50

Uploading data to our consolidated database fails when there is a lot of data. What we see in Mobilink monitor is that the "apply upload" keeps running and "never" stops. After 8 hours I shut down Mobilink to stop this connection. I also have the impression that I changed "something" that decreased the performance of Mobilink

For a upload that never finishes I unload the data to plain text files. The total number of bytes of these plain text files is 1.236.193.787 (1.15Gb).

* Is there a maximum number of bytes we can upload? Or, how can we find out why the "apply upload" keeps running.

* Is it possible to disconnect a remote id without shutting down Mobilink.

* Does the size of the log affect performance? Should we close down the database and rename the log?

* Concerning speed, i looked at a upload that finished without problems. I see: upload bytes 210282 apply upload: 1.194,322. Duration: 1.195,909

Anyone any ideas.

Thanks in advance,

Eric