3 ms·
The performance issue is easily solved by using an index. Getting page 500 would be just as fast as select * from table where 500100 <= order_num < 501100
by bjourne 7y ago
The performance issue is easily solved by using an index. Getting page 500 would be just as fast as select * from table where 500100 <= order_num < 501100