Usually a single transaction is faster than an insert a time (with or without union) > Date: Sat, 21 Mar 2009 12:05:18 +0000 > From: andrew4williams@xxxxxxxxx > To: php-general@xxxxxxxxxxxxx > Subject: how to make multiple sql run faster > > Hi all, > > I am inserting more than 5000 rows into sql database but its taking more > than 30 mins to get it all the data inserted. I use union to insert > multiple rows of 20 at a time. > > What is the best way to make insert sql statement run faster > > -- > andrew > www.willandy.co.uk _________________________________________________________________ More than messages–check out the rest of the Windows Live™. http://www.microsoft.com/windows/windowslive/
