Use Linux! This is the solution. If you have to use windows will need to tweak your TCP settings
Here is a tool that can help you. http://www.dslreports.com/front/drtcp.html - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 -->-----Original Message----- -->From: Mojtaba Faridzad [mailto:[EMAIL PROTECTED] -->Sent: Wednesday, September 24, 2003 1:10 PM -->To: [EMAIL PROTECTED] -->Subject: mySQL is slow with TCP/IP !!! --> -->Hi, --> -->I wrote some queries to check the speed. If the client and server both -->are -->windows NT, retrieving large number of records is very slow but when the -->client is windows 98 and server is NT, it works almost 20 times faster. -->Probably the problem is caused by TCP/IP which is much slower over the -->lan -->in windows NT, 2000, and XP. Do you know any solution for this problem? --> -->Thanks --> --> -->-- -->MySQL General Mailing List -->For list archives: http://lists.mysql.com/mysql -->To unsubscribe: -->http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]