Doesn't interbase have the ROWS nStart TO nEnd option in 6.5?

R.

-----Original Message-----
From: javier_castanon [mailto:javier_castanon@...]
Sent: Friday, March 21, 2003 3:13 PM
To: ib-support@yahoogroups.com
Subject: [ib-support] Strategies for resultset paging


Hi everybody!

I need to get rows from a large table that contains more than
100,000
records, and I wish to retrieve them in chunks of 10,000. I'm
looking
for strategies about writing a stored procedure to acomplish
this. I'm
aware that if I were using Firebird, I could use SELECT FIRST n
SKIP m,
but I'm releasing in these days and we can't afford another 3
weeks of
testing, due to the change from Interbase to Firebird.

I'm more acquanted with Oracle and SQL Server, so my first ideas
where
about using temp tables and internal table row numbers, but
AFAIK, those
features are not available in IB/FB, and since I'm building this
solution looking for the best performance possible, I'm asking
for
your advice.

Thanks in advance


Javier








Yahoo! Groups Sponsor
ADVERTISEMENT

<http://rd.yahoo.com/M=246920.2960106.4328965.2848452/D=egroupweb/S=1705
115386:HM/A=1481646/R=0/*http://www.gotomypc.com/u/tr/yh/cpm/grp/300_fla
ke/g22lp?Target=mm/g22lp.tmpl>

<http://us.adserver.yahoo.com/l?M=246920.2960106.4328965.2848452/D=egrou
pmail/S=:HM/A=1481646/rand=305411335>

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]