-----Original Message----- From: Ryan Stille [mailto:[EMAIL PROTECTED] Subject: Re: Why is this delete so slow? ( 90 seconds per 100 records)
Also the table seems to be locked while running this delete... thats not going to be very good when I need to run it on production. Is there a way to have it not be locked during this delete? [JS] Sorry, that violates the requirements of database consistency. What would happen if somebody tried to update a record that you had just deleted? You'd have to program a recovery mechanism into your application to handle that eventuality. I don't know if MySQL will let you delete without locking, I haven't delved into locking because my predecessor used MyISAM tables. His solution was to disallow deleting anything from the user interface. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
