LIMIT V4MD1

[Florian Bogeschdorfer]

Well not really...if I have a DB with some 100000 records and I do a "SELECT
* FROM TABLE" then I will create a huge cursor and need a lot of RAM and
speed, not? While a LIMIT 1 would decrease ressource consuming a lot.

Best regards, Florian

> Hi Florian,
> 
> > Hi!
> >
> > How can I do something like "SELECT * FROM TABLE LIMIT 1"?
> 
> Just build cursor,
> Then use its first N records.
> 
> Effect the  same
> 
> --
> Best regards,
> 
> Ruslan Zasukhin
/listinfo/valentina