 | | | Really big resultsets | Really big resultsets 2005-05-09 - By Corey Tisdale
Back
Hi all,
How do you deal with really big resultsets in such a manner that they do
not deny access to the tables for others? I have a situation where a
resultset could be anywhere from a few hundred to a hundred thousand
rows. Everything works fine speed-wise into the tens of thousands, but
once you get close to 6 figures there is a noticable speed hit. It seems
as though MySQL (v4.0.24) locks the tables as the result set is being
sent to the client, and I would much rather have the client just wait
for a little bit. I thought at first paging by using the limit 50000,
200 syntax would work (to go through 200 records at a time), but it
still gives me huge lapses in availability. What can I do to help keep
my tables available to all clients?
Thanks!
Corey
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=mysql@(protected)
Earn $52 per hosting referral at Lunarpages.
|
|
|