ADO connection slow on first load
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!
Subject
Written By
Posted
ADO connection slow on first load
June 22, 2005 01:32PM
September 15, 2005 08:13AM
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.