3000 items only display 50 once

searain

I have a table with 3000 items and I would only display 50 at one page.

Instead of on every page I do a search and grab all 3000 items (it is very
slow) and only display the certain 50 items. Is there an easy way to search
only the certain 50 items for the display of that page? Order by the name.
Such as select the 3201-3251 items etc.

My database is InterBase 6.0.

Any InterBase build in tool can let me do that?
If there is not build in function to let me do so in the database, are there any better php programming practice to improve the performance here?
To work with my graphic designer. I tried to put most php codes on top of every page before the <html> tag. To display the search results, I used to run sql and assign the values to the user defined arraies before <html> tag. and then In the html coding part, I only need to display the values of these arraies. No database, sql codes messed in the html part.

But if the search result is too big, this approach is slow. (duplicated the excutions, first assign the values to the arraies, and then display the values of the arraies.)

Any helps please.

Jarod

use limit

ex: SELECT * from user LIMIT 20

searain

No. In IB 6.5 or later you can do it easily with the ROWS clause. With
earlier versions you will need to write a stored procedure to return
the rows you want.

So when I do the query in the InterBase, I don't have the luxury just a simple query to return the rows from which number to which number.

And then in PHP, i will call the

while ($row=ibase_fetch_object($select_query_statement))

to fetch the returned rows, one by one.

Say if the rows are 100,000, and I only want the 99,900 to 100,000. I still have to go through the whole 100,000 rows? There must be an easy solution out there for us (If the database don't offer the select certain rows feature.)

Thanks!