On Mon, Dec 14, 2009 at 8:32 PM, D. Dante Lorenso <da...@lorenso.com> wrote: > I have an "items" table that is heavily updated with 40 million records > every 1 or 2 days and I need all those items indexed so they can be > searched. The problem that I'm having is that the table is constantly > locked because an insert or delete is being performed. > > I am playing with InnoDB vs MyIsam and have been trying to figure out how to > get the best performance.
Problem solved: use InnoDB. Writers don't block readers and vice versa. - Perrin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org