sybperl-l Archive

From: sy50027 at milton dot sbi dot com (Simon Yaminian)
Subject: Re: Queries n rows at a time
Date: Jul 15 1998 2:24PM

> From owner-SYBPERL-L@listproc.net Wed Jul 15 10:08:01 1998
> To: SybPerl Discussion List 
> Subject: Re: Queries n rows at a time
> From: David C Worenklein 
> Date: 	15 Jul 1998 10:05:58 -0400
> X-Listprocessor-Version: 8.2.07 -- ListProc(tm) by CREN
> 
> It depends on the query.  If there's a unique field, you can use it to 
> chop your query into blocks.  eg
> 
>    select id, name, address from employees
>    where state='NY' and id>$x and id<=$x+100
> 
> 
	Thanks for your reply.
Suppose you have the following query:

	select * from employees

How can you get those let's say 200 at a time and suppose you have 20,000
employees. The idea is, instead of waiting let's say 20 seconds to complete
the query, wait .2 second at a time and get some data to work with in the
meantime.

Regards
Simon Yaminian