Hi, The insert queries are run from the localhost on both the machines.
-Abdul On Fri, 2006-04-28 at 10:28 -0700, Atle Veka wrote: > On Fri, 28 Apr 2006, Mohammed Abdul Azeem wrote: > > > Hi, > > > > I have 2 mysql servers with version 5.0.15-standard-log running on > > redhat es4 installed on 2 different geographic locations. The default > > storage engine used is innodb on both the servers. I run an insert query > > on both the servers that inserts 25,00,000 records. first server takes > > 7.5 hrs, while the second server takes around 17 hrs for the same > > process. > > Are these queries run from localhost or from a remote location? It's very > unusual for an IDE based system to outperform SCSI. > > > Atle > - > Flying Crocodile Inc, Unix Systems Administrator > > ======================================== > ________________________________________ > This email has been Scanned for Viruses! > www.newbreak.com ________________________________________ This email has been Scanned for Viruses! www.newbreak.com ======================================== -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]