Re: Re: Using large result sets from a database

I'm sorry for leaving out some of the important info:

(Unfortunately) my DBMS is MS SQL Server 7.0. I don't like that, but unfortunately it's what I'm stuck with. It's hard being the UNIX guy (err, the voice of reason) in a Win32 shop. . . but anyway, I'm using DBI-ODBC to connect, and I have Apache 1.3.19 with mod_perl 1.25.

Thanks for the info :)

Comment on Re: Re: Using large result sets from a database

Replies are listed 'Best First'.
Add a where clause to bound the return each time. by hackmare (Pilgrim) on Jun 07, 2001 at 20:44 UTC
Something you can also try, but which is more cumbersome, is to track the key values for your table if you've got sequential or orderable keys, or alternatively add a counter in a subquery and select for the range within that subquery that you pass the server within the query. As you're using MS SQL Server, look into the SYBASE documentation since they are 90% the same product. My guess is that they have this already taken care of using LIMIT or an equivalent. --hackmare	[reply]

Replies are listed 'Best First'.

Add a where clause to bound the return each time.
by hackmare (Pilgrim) on Jun 07, 2001 at 20:44 UTC

Something you can also try, but which is more cumbersome, is to track the key values for your table if you've got sequential or orderable keys, or alternatively add a counter in a subquery and select for the range within that subquery that you pass the server within the query.

As you're using MS SQL Server, look into the SYBASE documentation since they are 90% the same product. My guess is that they have this already taken care of using LIMIT or an equivalent.

--hackmare

[reply]