That fixed it, Thanks! -----Original Message----- From: Mirza [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 25, 2004 7:46 PM To: [EMAIL PROTECTED] Subject: Re: Speeding up Inserts
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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]