Skip to Content
author's profile photo Former Member
Former Member


Dear colleagues,
A customer uses SQL Anywhere 9, if they start the database with dbsrv9, the operation on database is very slow(about 20 minutes). And if they start the database with dbeng9,the same operation on database is fast(about 30 seconds.) The total operations are as following,
(1) The app connects to the Application Server to get some data, then disconnect from the Application Server;
(2) The app connects to the SQL Anywhere 9 database to do some operation(including select, update, insert, etc.)

In the past they uses SQL Anywhere 9 as standlone (The app and database on the same compute), now they want to use SQL Anywhere 9 as network(the app and database on the seprate computers).

From the operation system network monitor there is the much following info,
#1 0x40e836e1 in Java_com_sybase_asa_logon_ASAConnect_shutdownEngine () from /smc20/sybase/

What's the posible reason about this, and is there some configuration to resolve this?


Jun Wang.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jul 21, 2014 at 06:41 PM

    You haven't supplied enough information to get a good response to your question. You should include information like:

    Is the hardware where the database server is running the same in both cases?

    Is the database the same in both cases?

    Is the network connection fast? How long does it take to copy a file over the network?

    Is the application going through the application server in both cases?

    There are various tools you can use to look at performance. They are documented here:


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.