Hi! >If I have a process inserting into an innodb table in 200 insert chunks. >i.e. it commits after every 200 inserts, must another process, which wants >to delete data from this table, wait for the next commit on the insert end? >If not is there any reason why my process is doing this.
Do you have an index which guides the delete so that it will not need to look at the new inserted rows? >Ric Regards, Heikki -- Order commercial MySQL/InnoDB support at https://order.mysql.com/ --------------------------------------------------------------------- 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
