Indexes slow down inserts, updates (if the indexed column is being updated),
and deletes.
If this is a data-refresh, consider dropping the indexes, importing the data,
and then indexing the table.
You haven't mentioned how you are getting the data into the database? Is this a bulk-load? Insert statements? Some piece of code
selecting from one database and inserting into MySQL 5.0?
If you are using mysqldump to get data out as insert statements, use the
extended-insert, as it's much much faster.
David
Vinay wrote:
I am using mysql5.0 on Hp-UX. IT took about 14 hours to insert 1.7
millin records. How do I make my insert run faster.The table has three
foreign key references and the referencing columns are indexed . Is that
impacting the insert statement performance.
Thanks for the help
Vinay
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
