On Monday 22 October 2001 18:25 pm, Priya Ramkumar wrote: > Hi Tom, > > Thanks for your response. It takes around 1 hour & 40 minutes to > insert 28000+ records. Also, I find that the first few thousand > transactions are quite fast but slows down later. I have MySQL on > Linux. I have a concatenated primary key of multiple fields. And I > also have a unique index on each of these fields. There are > 1,734,291 bytes of data in the table with an average row length of > 61.
Sometimes it's quicker to drop the indices, insert your data, then recreate the indices. hth -- Jason Wong Gremlins Associates www.gremlins.com.hk --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php