Skip navigation links

MySQL Forums :: Microsoft SQL Server :: ADO connection slow on first load


Advanced Search

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


Subject Written By Posted
ADO connection slow on first load David Drury 06/22/2005 01:32PM
Re: ADO connection slow on first load Jeromy Dean 06/27/2005 09:50AM
Re: ADO connection slow on first load Alden Law 09/15/2005 08:13AM
Re: ADO connection slow on first load Mpiangu emmanuel 04/10/2008 10:32AM


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.