At 04:16 AM 11/23/2004, Bernd Heller wrote:
Hi Mike,
I tried read-locking the tables as you suggested, but regrettably it
didn't help a bit. If there is nothing running but selects on that
database, mysql shouldn't lock ever, should it? or is it locking the table
if it's doing a full table scan
Hi Mike,
I tried read-locking the tables as you suggested, but regrettably it
didn't help a bit. If there is nothing running but selects on that
database, mysql shouldn't lock ever, should it? or is it locking the
table if it's doing a full table scan (why?!)?
Bernd
On 23.11.2004, at 5:39 Uhr,
At 06:10 PM 11/21/2004, you wrote:
Hi all,
I've got a rather odd performance problem with concurrent queries here. My
query regrettably always needs to do a full table scan - really can't be
helped. So my
idea was to cache the data in a HEAP table to get maximum performance out
of it and it work
Hi all,
I've got a rather odd performance problem with concurrent queries here.
My query regrettably always needs to do a full table scan - really
can't be helped. So my
idea was to cache the data in a HEAP table to get maximum performance
out of it and it works really well, I'm down to 0.07 sec
