MySQL Forums
Forum List  »  Performance

How to reduce number of locks
Posted by: Paul Oyster
Date: November 08, 2004 02:03AM

I have an ISAM table that is being queried and altered frequently.
My multi-threaded application uses the C APIs, with a separate database connection for each thread.

The application guarantees that no two threads touch the same row (a trivial example would be: two threads, one only deals with rows with odd index values, and the other thread with the even values).

The question is what table-locks are necessary here: one for each query and/or change ? for changes only ? none at all ?

Options: ReplyQuote

Written By
How to reduce number of locks
November 08, 2004 02:03AM
November 08, 2004 02:45PM
November 09, 2004 10:08AM
November 09, 2004 10:25AM

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.