Page 1 of 1

TZQuery Fetch All

Posted: 26.08.2009, 15:32
by sat
Hello,

How to execute sql statement and fetch all with TZQuery? Or how to execute a sql statement like "SELECT * FROM MyTable ORDER BY MyField" with TZQuery and navigate records as fast as TZTable? i'm using ZEOS 6.6.5 and Firebird 2.1.

Posted: 02.09.2009, 21:58
by mdaems
TZTable is a TZQuery, so it shouldn't make a difference from the zeoslib side. The sorting in TZQuery happens server side. So this might cause some wait between opening the query and reading the first record. After that both methods should be equal.

Mark