[EMAIL PROTECTED] wrote:
> 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?
>
Take a look at LOAD DATA statement:
http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
ALER TABLE .. DISABLE KEYS / ALER TABLE .. ENABLE KEYS also may help you:
http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html
Check also the following sction of the manual:
http://dev.mysql.com/doc/mysql/en/Insert_speed.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
