Hi everyone~~
I have a program inserting data into myisam tables continuously by queries
like "insert into table1 select * from table2". I need an insertion speed
about 1,000 entries per second with the average entry length of about 50
bytes. But the actual speed of the insertion is only about 450 entries per
second. If I comment the code doing insertion, the program can reach a
speed about 1600 entries per second. So is there any way to tune mysql to
improve the insertion speed ?
Thanks! :)
_________________________________________________________________
您可以在 MSN Hotmail 站点 http://www.hotmail.com/cn 免费收发电子邮件
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
