MySQL Forums
Forum List  »  Connector/ODBC

OBDC connect slow with ASP
Posted by: Tobias Aspenberg
Date: October 01, 2004 01:41AM

Hi!

I use the MySQL ODBC 3.51 Driver with an ASP page to get access to the MySQL database.

The problem I have is that it takes awefully long to connect to the database the first time..

The connection string is:

db_connstr = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=XXX.XXX.XXX.XXX; Port=3306; DATABASE=XXX; OPTION=3; USER=XXX; PASSWORD=XXX;"

and the script totally halts at the use of:

db_conn.open db_connstr

(checked it thru response.write/flush)
that statement probably takes about 15 seconds the first time it's executed and then it continues to execute.

If I reload the page or continue to execute things right away it's really fast but if I wait a few minutes the initial connection is just as slow again.

Unfortunately my Googleing hasn't produced any good explanaitions for this....

Have anyone a solution or has experienced the same?


Options: ReplyQuote


Subject
Written By
Posted
OBDC connect slow with ASP
October 01, 2004 01:41AM
October 09, 2004 07:47AM
February 07, 2005 01:28PM
October 11, 2004 10:43AM
H B
October 20, 2004 11:22AM
November 03, 2004 05:45PM
November 07, 2004 05:39AM
November 29, 2004 01:57PM
November 30, 2004 05:30AM
December 02, 2004 01:17AM
March 10, 2005 10:59AM
March 11, 2005 02:53AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.