|
Posted by Chung Leong on 09/16/05 08:22
nospamm...@gmail.com wrote:
> I do not use any manual locking as I do not need atomic transactions.
> So I think locking shouldn't be an issue.
I'm not terrible familiar with MySQL. Perhaps someone can correct me if
I'm wrong. I think MySQL uses table locks for write operations. So you
could have situations wheere a select is blocked by a pending insert
which itself is blocked by an outstanding query.
I would research the topic of MySQL optimisation a bit more before
rolling your own shared memory system.
Navigation:
[Reply to this message]
|