Re: Servlets and Searching the Database
Friday, March 23, 2001 03:55 PM
Use the SQL command parameter LIMIT.
Here's an example.
SELECT * FROM TABLE_NAME LIMIT 0, 1000
That would pull 1000 results starting at postion 0 (the first , so the next pull would look something like.
SELECT * FROM TABLE_NAME LIMIT 1000, 1000
Which would pull 1000 results starting at result 1000.
Then all you have to do is keep track of wich set you're at, and dynamically generate the next link accordingly.