Limiting cursor size

[Chris Kelly]

I believe Mysql  just uses the keyword LIMIT

If this was something you were considering Ruslan , would you also 
think about being able to define a starting offset for the cursor?

So if you were dealing with large volumes of data you could use LIMIT 
and supply an offset as well for the data ,   so in effect  you were 
just obtaining  the next N rows of data in the cursor from the offset ?

I know this is  used this extensively with php and mysql.

Chris


On Friday, June 13, 2003, at 05:12  AM, Gunnar Swan wrote:

>
> 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.
Ruslan wrote :
>> 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
>
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
>
Chris Kelly
IT Manager
QFS Australia
ph 61 7 3277 0877
fax 61 7 3277 0026