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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]