Re: Speeding up Inserts

[mos]

At 08:55 AM 5/25/2004, you 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
Amit,
        Use Load Data Infile if the data is coming from a text file. To 
load 30k rows should take a few seconds.

Mike 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]