merge tables and table locks
We have a large MyISAM table that we are constantly inserting into and selecting from. There is a bottle neck because the INSERT's lock the entire table.
We are thinking of creating smaller base tables and merging them. We would INSERT into the base tables which would limit the locks to a smaller number of rows; and SELECT from the larger merge table.
Will this work? Will write locks on a base table also lock the merge table?
Thanks,
Jay
Subject
Views
Written By
Posted
merge tables and table locks
7370
March 13, 2007 04:17PM
4798
March 13, 2007 08:46PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.