RE: copying databases to avoid insert holdups

2003-02-26 Thread Jeremy Tinley
-J -Original Message- From: Seth Brundle [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 2:01 PM To: [EMAIL PROTECTED] Subject: copying databases to avoid insert holdups I have a MySQL database I will be launching soon which has a search engine database accesable over DBI

copying databases to avoid insert holdups

2003-02-26 Thread Seth Brundle
I have a MySQL database I will be launching soon which has a search engine database accesable over DBI/mod_perl/Apace. It has about 2M records, and is a 4GB table with 1GB index. Every day I insert 76k records all at once and delete about another 76k. While these inserts are happening, the select