MySQL Forums
Forum List  »  Microsoft SQL Server

ADO connection slow on first load
Posted by: David Drury
Date: June 22, 2005 01:32PM

We are switching an ASP based web app from SQL Server to MYSQL. I'm finding that the initial hit (connection) to the database is 30-40 seconds slow (compared to milisecond response with SQL Server). For approx 30 seconds you can refresh the page with no lag problems (the connection object I presume is alive/ in sleep on the server).

Would anyone know of an answer to this? I have tried changing the OPTION parameter of the connection string, but to no avail... See below for a sample of how the connection is opened:

set cn = Server.CreateObject("adodb.connection")
cn.Open "Driver={MySQL ODBC 3.51 Driver}; Server=server; Database=database; UID=LoginID; PWD=LoginPWD; OPTION=" & 1 + 2 + 8 + 32 + 2048 + 16384

Any help would be much appreciated!

Options: ReplyQuote

Written By
ADO connection slow on first load
June 22, 2005 01:32PM

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.