ibase_fetch_object jump to the certain rows of the query result?

[searain]

Say if I use InterBase query get a large number query results, 100,000 items returned in the results. And I only want to display the results from 99,990 to 99,995.

And unlike the MySQL, InterBase (version 6.5 before) doesn't have the search limited by rows feature. So I guess I have to query all the 100,000 results out instead of like MySQL only query the 5 items I want by limit the rows.

To display the results, I have to use

while ($row->ibase_fetch_object($select_query)) to go over these 100,000 objects one by one, until i reach the 5 objects I wanted, 99,990th to 99,995th.

It is too slow to execute.

If no SQL solution for InterBase here, could I use some coding tricks here to solve this problem?

I think in ASP, I can jump to certain row and then only grab the values of that row and the rows following. But I don't find ibase_fetch_object will let me jump to the middle of the query results.

How could I do that? Jump to the middle of the results and only grab certain number of the results I want.

Thanks!

[searain]

Is there anyway to let me skip fetch the unnecessary objects? I think ASP recordsets we can jump to certain row number. Is that anyway in PHP interbase handling feature to do the same too?

Or maybe I should write a stored procedure in InterBase and only return the certain rows I want. Then the fetch object will be only to these rows I want.

Any help? please.