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
