For your information, I updated my ODBC driver for mySQL to the latest version 3.51.12 and the slow connection problem has disappeared.
From: [EMAIL PROTECTED]: [EMAIL PROTECTED]: RE: Slow Access When Inserting RecordsDate: Thu, 12 Oct 2006 19:01:08 +0000 Hi, I've tested the exact same ASP pages on my local computer, and the pages load very quickly. Therefore there must be a problem with dedicated windows server. Any ideas what the problem might be ?Thanks,Neil > Date: Sun, 8 Oct 2006 17:17:07 -0500> To: mysql@lists.mysql.com> From: [EMAIL > PROTECTED]> Subject: Re: Slow Access When Inserting Records> > At 01:56 PM > 10/8/2006, Neil Tompkins wrote:> >Hi,> >> >We have a mySQL database running > version 3.23.58 on a linux machine.> >> >This database is accessed from both > a Windows IIS web server and a linuz > >zeus web server. On the linux server > I'm not sure of what driver etc is > >installed, however the access time to > save a record is far quicker than > >the windows server. On the windows > server ODBC driver 3.51 is installed.> >> >We don't appear to have the > problem when reading data from the server > >(SELECT FROM etc).> >> >All > servers are on the same network.> >> >All data is accessed using ASP (active > server pages, vb script).> >> >Any ideas what the problem might be ?> > >Thanks,> >Neil> > Neil,> How much quicker is Linux over Windows? > How many rows are you > adding at a time?> > The first thing to > check is your NIC. How fast is the Windows NIC > compared to the Linux NIC? > Test your network to see what throughput you can > achieve from each of them. > A> > Mike > > -- > MySQL General Mailing List> For list archives: > http://lists.mysql.com/mysql> To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED]> Be one of the first to try Windows Live Mail. _________________________________________________________________ Be one of the first to try Windows Live Mail. http://ideas.live.com/programpage.aspx?versionId=5d21c51a-b161-4314-9b0e-4911fb2b2e6d
