Zeoslib Portal

Im using postgres and a zquery select * from items and using fetchrow = 10 but it still loads all query rows on the open. I only want 10 rows on start up and the rest as it is needed ...


How i fetch only 10 by 10 rows ?

Any effective answer ?

Is it working ,

Hello

FetchRow works ,i mean : i test it with Firebird and have the effect i hope. i wrote this "expérience" in a tutorial still in progress you can find herehttp://serge-girard.developpez.com/tuto ... p/ZeosDBO/ , hopping the tutorial is accessible )

if you want to only have the 10 first rows then use limit
i.e.

It works for all plains. But this value only indicates count of row which are fetched from query.
It's no Limit/Offset sql change if you expect this.