In order to post questions, answers, or comments, you now need a validated email address. Details on how to validate your address are in the FAQ.

Recently,Our customer complained that the mobilink upload is very slow and causing remote application hang in a production environment . so we did a sync test with the following scenario.

Server 1) Adaptive Server Anywhere MobiLink Version 9.0.2.3389 2) IBM AIX 5.3 with 62GB Memory 3) Sybase ASE EE as Consolidated database Client 1) Windows XP 2) Adaptive Server Anywhere MobiLink Version 9.0.2

Network LAN

Mobilink Sync took 45 min to upload 5000 rows in a table for a single client . we are puzzling why is it taking such a long time ?

asked Jul 03 '12 at 22:03

vhm's gravatar image

vhm
210121320

More information is needed, starting with the verbose diagnostic log files from both the MobiLink server and MobiLink clients.

"%ASANY9%\win32\dbmlsrv9.exe" -o dbmlsrv9_log.txt -os 1M -v cfhnpstu ...

"%ASANY9%\win32\dbmlsync.exe" -o dbmlsync_log.txt -os 1M -vnosu ...

Post the files here. They will help answer the FIRST question, "Where is the time going? On the remote client computer, on the network, or on the consolidated server computer?"

You won't be able to upload the files until you get 100 of those "reputation points" on this forum, so if they are too large to post inside your question, email them to me at breck carter gmail com.

There may be more questions to follow.

(Jul 04 '12 at 05:16) Breck Carter

Hi Breck,

Thanks for your response. I will post the information once i finished the diagnostic based on your recommendation.

Thanks

(Jul 04 '12 at 06:10) vhm
Replies hidden
Comment Text Removed
Comment Text Removed
Comment Text Removed
Comment Text Removed
Comment Text Removed
Comment Text Removed
Comment Text Removed
Comment Text Removed
Comment Text Removed
Comment Text Removed
Comment Text Removed
Comment Text Removed
Comment Text Removed
Comment Text Removed
Comment Text Removed
2

Can you please attach the files to your question rather than put them in comments? They are not formatted so all the lines run together, plus the fact that they are split over a bunch of comments makes them very difficult to read. As Breck said, normally you need a reputation score of 100 before you can upload but I have temporarily reduced that so you can attach the files. Please delete all the comments once you have done that.

(Jul 05 '12 at 23:37) Graeme Perrow

answered Jul 06 '12 at 00:30

vhm's gravatar image

vhm
210121320

Please try again.

This time, please run a synchronization that works, not one that fails... if the failure is the problem, not performance, please ask a different question.

Also, please do not use -v+.

Please use the the -v option values that were suggested earlier (-v+ includes "r" which produces thousands of lines of unnecessary output that makes analysis much more difficult):

"%ASANY9%\win32\dbmlsrv9.exe" ... -v cfhnpstu ...

"%ASANY9%\win32\dbmlsync.exe" ... -vnosu ...

(Jul 06 '12 at 06:16) Breck Carter
Replies hidden

@Breck: And you do know these -v flags by heart, dont, you? I'm impressed...

(Jul 06 '12 at 06:27) Volker Barth

Nothing to be impressed about. I have template *.bat files for executing db*.exe stuff. IMO -v+ should be removed from the product.

(Jul 06 '12 at 07:03) Breck Carter

Hopefully, you did not start the MobiLink server with -dl, because -dl will force the MobiLink server to display every single message on the GUI and it will dramatically reduce the performance. Both the upload_insert script and data look very reasonable. Do you have any triggers defined for the upload table? Please also check the CPU utilization of the machine that runs ASE, when the sync is running.

(Jul 07 '12 at 17:13) Yufei Guo
Your answer
toggle preview

Are you providing an answer to the original question, or making a comment on the question or an answer? If you are making a comment please do not post a new answer. Click "Add new comment" on the question or answer instead. If you are responding to a previous comment, click on the "reply" icon (    ) for that comment.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link: [text](http://url.com/ "title")
  • image: ![alt text](/path/img.jpg "title")
  • numbered list (indent for sublists):
    1. Foo
    2. Bar
  • bullet list (indent for sublists):
    * Foo
    * Bar
  • to add a line break, add two spaces to where you would like the new line to be.
  • Code blocks should be indented by 4 spaces. SQL code should begin with ":::SQL" on the first line.
  • basic HTML tags are also supported

Tags:

×185
×170
×3

Asked: Jul 03 '12 at 22:03

Seen: 737 times

Last updated: Jul 07 '12 at 17:13

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link: [text](http://url.com/ "title")
  • image: ![alt text](/path/img.jpg "title")
  • numbered list (indent for sublists):
    1. Foo
    2. Bar
  • bullet list (indent for sublists):
    * Foo
    * Bar
  • to add a line break, add two spaces to where you would like the new line to be.
  • Code blocks should be indented by 4 spaces. SQL code should begin with ":::SQL" on the first line.
  • basic HTML tags are also supported