Re: Are queries queued?
Sorry, I guess I did not "go easy on you". Nor did I really address your original question. (I guess I have a habit of looking for the 'real' question.)
MyISAM, when using LOCK will queue queries up and execute them one at a time.
InnoDB, will attempt to do things in parallel, but since the query may find the same rows (eg when 2 SELECTs get executed before the first UPDATE gets COMMITted), the parallelism is more like; the queries will stumble over each other.
For either engine, 1000/sec is optimistic; 100/sec is probably feasible. But lack of indexes, use of ORDER BY, etc can seriously impact those numbers. If you explain your 'real' goals further, we can be less vague in our answers.
Subject
Written By
Posted
Re: Are queries queued?
May 16, 2009 07:26PM
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.