Re: select limit records from 600000 records
Posted by:
Rick James
Date: October 31, 2009 02:53PM
If you have an auto_increment on the table, and there are no gaps (due to deletions), this points out very efficient way:
http://forums.mysql.com/read.php?24,285339,285585
And it discusses how to set it up if you do have gaps.
Similar:
http://forums.mysql.com/read.php?24,280256,280871
These suggests ways, but with a costly one-time setup:
http://forums.mysql.com/read.php?52,226769,228906
http://forums.mysql.com/read.php?10,239325,239348
Subject
Written By
Posted
Re: select limit records from 600000 records
October 31, 2009 02:53PM
November 02, 2009 11:19AM
November 03, 2009 12:19AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.