Hi, The difference is noticeable (sometimes 15 seconds), as it is being performed on a webpage. The slow server is running at 100mb and ping times to the database server are 1ms or less. Could the problem with be IIS ? 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. http://ideas.live.com/programpage.aspx?versionId=5d21c51a-b161-4314-9b0e-4911fb2b2e6d
