Re: OBDC connect slow with ASP

[lynn]

You can solve this by having proper name resolution, or if you are using only ip's for hostnames then you can disable name resolution.

You can do this rather easly through the new MySQL Administrator application.

Got to the 'Server Variables' view, then to then 'Networking' tab. You'll see the 'Disable name resolving' option at the botton. Check that box and it works like a charm.

More specifically use these in you my.cnf (or my.ini for windows).

#Don't cache host names.
skip-host-cache
#Don't resolve hostnames. All hostnames are IP's or 'localhost'.
skip-name-resolve

I like the mysql 4.1 set up wizard. But it could be improved if they provided a screen that easily enabled 'legacy support' such as disabling these, usinging old password, etc. Or at least, a read me that discusses these snafus possible with these new configuration settings.

You WILL NOT find these under '5.2.3 Server System Variables'. They NEED to be there.