Limiting cursor size

[Ruslan Zasukhin]

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
-------------------------------------------------------------