MySQL Forums
Forum List  »  Connector/ODBC

Re: OBDC connect slow with ASP
Posted by: Erik Hoekstra
Date: March 10, 2005 04:56AM

Old thread but same problem.
However, to me the problem seems more related to Windows 2003 than MySQL or the ODBC-driver.
We experience this problem since we migrated our websites to a new Windows 2003-server very recently (last week). These websites (ASP) connect to two different database-servers (both MySQL/Linux), as they did before. The old webserver had the Windows 2000 OS.
We never had this problem back then, not with MySQL ODBC 3.51.6/9/10 nor MySQL 3.23/4.1

Also the behaviour of this problem seems pretty consistent. The first connection to the database-server takes 21 seconds every time. This is only just the connect-method of the ADODB-object. The query and data-return are almost instantly, independent of complexity of the query (these responsetimes are more related to hardware-resources and tuning, and not to this connection-problem). Also the webpage is delivered by the server without delay. So we pinpointed the problem down to the webserver building the ADODB-connection with the database.

The next thing is that if the connection is reused within approx. 2 minutes, there's no delay. If idle-time is longer, then is takes 21 seconds again.
So, it seems more like a caching or keepalive-problem in IIS (6) or Windows 2k3.

I noticed that the connection-timeout for websites is set to 120 seconds by default (IIS-manager, websites-properties). Now I'm not an expert on network-traffic and all that stuff, but this seemed a possible/plausible cause. However, setting the connection-timeout to 1200 sec didn't help.
Also, other programs (on the same server) that use the ODBC to write to our database-server don't seem to have this problem (we run a SYSLOG-agent that writes the windows events to the MySQL-database).

More arguments that point in this direction are given all over the Internet. Microsoft has changed a lot of defaults in Windows 2003, regarding TCP/IP and IIS. This is basically a good thing for better security, but annoying because of a lack of transparency and the time-consuming quest for answers (not mentioning the stress when you have customers to serve) .

So for now I'll continue looking for those obscure Windows/IIS-settings.
Any help will of course be much appreciated.

Options: ReplyQuote


Subject
Written By
Posted
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
Re: OBDC connect slow with ASP
March 10, 2005 04:56AM
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.