I have a couple of questions here. This table currently contains about 12 million records. This table is mostly read from, but several times thoughout the day there will be inserts or updates of batches of about 30,000 rows, and there are periodic purges of old rows, which could be up to several million rows. The table has 1 index over three of the columns. My questions are:
1. There is one varchar(15) column, that is part of the index. Would there be any performance benefit to making it a char column? 2. Does InnoDB do updates/deletes row by row, even if it is just one query? 3. Will it just update the index once per query, or for each row? 3. Any other advice for speeding up the updates/deletes? --------------------------------------------------------------------- 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
