Limiting cursor size

[Gunnar Swan]

Some database engines use a MAX or TOP function in SQL
so that MAX(50) returns 50 records, TOP(50) 
This is nice for client-server or web based application.


6/12/03 12:11:09 PM, Ruslan Zasukhin <sunshine at public.kherson.ua> wrote:

>on 6/12/03 16:04, Erik Mueller-Harder at lists at praxisworks.com wrote:
>
>> It's probably staring me in the face, but I cannot find the answer to this in
>> the documentation.
>> 
>> Is there a way to limit the size of a cursor?  Often, I find I'm interested in
>> only the first row or two in a cursor that might have a few hundred rows in it
>> -- and I'd like to tweak things so I don't incur the extra overhead of 100s of
>> rows.
>> 
>> I guess I'm thinking something like:
>> 
>>   SELECT FIRST foo, bar from myBO WHERE foo = 'some value'
>> 
>> Can this be done?  Or in fact are cursors so well fine-tuned that there'd be
>> no performance benefit anyway?
>
>Hi Erik,
>
>This is not implemented,
>And in some cases this CAN improve performance
>
>-- 
>Best regards,
>Ruslan Zasukhin      [ I feel the need...the need for speed ]
>-------------------------------------------------------------
>e-mail: ruslan at paradigmasoft.com
>web: http://www.paradigmasoft.com
>
>To subscribe to the Valentina mail list go to:
>http://lists.macserve.net/mailman/listinfo/valentina
>-------------------------------------------------------------
>
>_______________________________________________
>Valentina mailing list
>Valentina at lists.macserve.net
>http://lists.macserve.net/mailman/listinfo/valentina
>


Best Regards,
Gunnar Swan
Practice To Pass
1.888.307.2050
http://www.PracticeToPass.Com