At 09:03 PM 6/19/2002, you wrote:
I am using MySQL 3.23.51 on Linux. I have a fixed-length table with 45
million rows. It appears MySQL has an efficiency issue with the LIMIT
command. When I run SELECT a FROM b LIMIT 0, 100 -- that's one
million
The query finishes almost immediately.
Hi.
On Wed 2002-06-19 at 20:03:32 -0600, [EMAIL PROTECTED] wrote:
[...]
But when I run 20 million rows into the dataset, it really slows down.
(pretend the commas aren't there)
SELECT a FROM b LIMIT 20,000,000, 1,000,000
Why would it slow down? We're dealing with a fixed-length table
