On Mon, Oct 26, 2009 at 10:28 AM, Alvaro Herrera
wrote:
> silly escribió:
>> 2009/10/26 Grzegorz Jaśkiewicz :
>> >
>> >
>> > On Mon, Oct 26, 2009 at 10:30 AM, silly wrote:
>> >>
>> >> Suppose that you have a query, say $sql_query, which is very
>> >> complicated and produces many rows. Wh
silly escribió:
> 2009/10/26 Grzegorz Jaśkiewicz :
> >
> >
> > On Mon, Oct 26, 2009 at 10:30 AM, silly wrote:
> >>
> >> Suppose that you have a query, say $sql_query, which is very
> >> complicated and produces many rows. Which of the following is going to
> >> be faser:
> >>
> >> $sql_
2009/10/26 Grzegorz Jaśkiewicz :
>
>
> On Mon, Oct 26, 2009 at 10:30 AM, silly wrote:
>>
>> Suppose that you have a query, say $sql_query, which is very
>> complicated and produces many rows. Which of the following is going to
>> be faser:
>>
>> $sql_query OFFSET 3000 LIMIT 12;
>>
>> or
>>
2009/10/26 Grzegorz Jaśkiewicz :
>
>
> On Mon, Oct 26, 2009 at 10:30 AM, silly wrote:
>>
>> Suppose that you have a query, say $sql_query, which is very
>> complicated and produces many rows. Which of the following is going to
>> be faser:
>>
>> $sql_query OFFSET 3000 LIMIT 12;
>>
>> or
>>
On Mon, Oct 26, 2009 at 10:30 AM, silly wrote:
> Suppose that you have a query, say $sql_query, which is very
> complicated and produces many rows. Which of the following is going to
> be faser:
>
>$sql_query OFFSET 3000 LIMIT 12;
>
> or
>
>BEGIN;
>DECLARE cur1 CURSOR FOR $sql_que
Suppose that you have a query, say $sql_query, which is very
complicated and produces many rows. Which of the following is going to
be faser:
$sql_query OFFSET 3000 LIMIT 12;
or
BEGIN;
DECLARE cur1 CURSOR FOR $sql_query;
MOVE 3000 IN cur1;
FETCH 12 FROM cur1;
COMMIT;
Nat
