Use:
ALTER TABLE DISABLE KEYS ... inserts here.... ALTER TABLE ENABLE KEYS
mirza
[EMAIL PROTECTED] wrote:
Hi All,
Whats the fastest way to speed up inserts?
I have a table which I insert into once a week (about 20-30k Rows)
And select from all the time...
Is the only way to speed up inserts to remove indexes? And to speed up selectes, ...add the indexes again?
Regards, Amit
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]