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.
Thanks Priya ------------- > Priya, > > Need more information ... how long does it take to insert 28,000 records? > On what kind of platform? How much data do the records contain? What kind > of primary keys and indices do you have? > > > Tom Haapanen > [EMAIL PROTECTED] > > > -----Original Message----- > From: Priya Ramkumar [mailto:[EMAIL PROTECTED]] > Sent: 22 October 2001 06:01 > To: [EMAIL PROTECTED] > Subject: faster inserts & updates > > I have a PHP program which adds records to a MySQL table. The number of > records in the table after the execution of the program is around 28,000. I > also have select & update queries in the program on the same table. The > process takes a very long time to complete all insertions to the table. I > already tried "Insert Delayed" on a sample segment of data but found that it > does not speed up things. Can anyone suggest a method so that the > insertions & updates to the table can be faster? > > --------------------------------------------------------------------- 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