Priya, I suspect that the primary key and index are causing your problems -- each time you insert, MySQL must create the indices and validate for uniqueness.
Can you remove the indices and try it that way? If that is very fast (as I suspect it will be), then you can focus on coming up with a more efficient way of indexing the table. In general, if your database is 99% reads (as ours is, and so are most other web sites), it makes sense to do fairly heavy indexing, as the savings on queries far outweighs the cost on updates. But if that doesn't describe your database, you should reduce the amount of indexing in order to speed up your inserts... Tom Haapanen [EMAIL PROTECTED] -----Original Message----- From: Priya Ramkumar [mailto:[EMAIL PROTECTED]] Sent: 22 October 2001 06:26 To: Haapanen, Tom Cc: [EMAIL PROTECTED] Subject: Re: faster inserts & updates 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 --------------------------------------------------------------------- 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
