ADO connection slow on first load

[David Drury]

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!