1 - while your current select query is reasonably fast, it likely could
be faster. It may be that it's taking 0.9 seconds and feels fast, but
perhaps it could be 0.09 seconds instead - and that's not something a
human can really tell the difference on. It's using an indexed column
(status),
Hi, list!
I have a little table (about 0.5 milloin records) which is kind of
queue. My perl script takes records from it one by one and does somes
actions.
Here's my table structure:
mysql desc queue;
Hi, Eugene!
I suspect that you have run into locking issues with your table, which I
am guessing is a MyISAM table. MyISAM provides only table-level locking
- that is, only one write operation can occur at any time on the table.
Other operations are blocked until their turn comes.
It
Hi, Eugene!
Sorry, my last post was sent too soon.
I suspect that you have run into locking issues with your table, which I
am guessing is a MyISAM table. MyISAM uses table-level locking - that
is, only one write operation can occur at any time on the table. Other
operations are blocked