Devart Forums

Posted: **Wed 21 May 2008 16:08**

Hello,

When I try to Open TMyConnection on design mode, it took too much time, I use the direct mode with user has all the privilege for the database I want to use, when I change the host to "localhost" instead of computer name and using Root user, it's open very fast, why if I use the computer name instead of localhost, opening connection is slow?

btw, I don't run any firewall

Regards,

Posted: **Wed 21 May 2008 19:24**

if u use remote DB, u must set params on MySQL my.ini
write this on the end of file

Code: Select all

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

Posted: **Thu 22 May 2008 14:02**

thanks tltmusashi,

however, i'm still facing the same problem, I just use the mysql and mydac on the same Pc, and don't connect to remote db, it's strange that it's too slow to open connection even i dont' have any tables on the db

Posted: **Mon 26 May 2008 14:48**

It is possible that it is related to problems with network.
Try connecting to MySQL server with Telnet using computer name. If connection opens too slow, try changing network settings.

Devart Forums

TMyConnection.Open is too slow

TMyConnection.Open is too slow