ZQuery vs ZReadOnlyQuery

[k1attila1]

Hi

Could somebody tell me what is the difference between

ZQuery + Readonly=True and ZReadOnlyQuery ?

Mainly speed ? or somthing else ? (FireBird SQL)

Thank you Attila

[marsupilami]

Hello Attila,

usually there should not be a big difference. But for some reason there is a notable difference - with Firebird at least. Use a TZReadOnlyQuery if you are sure, you don't need to modify anything.

With best regards,

Jan

[k1attila1]

Thank you Jan, to clarify.
Attila

[Fr0sT]

ZReadOnlyQuery executes queries (even modificating ones!) and returns resultset.
ZQuery additionally allows modification of this result set and posting it to DB.
ReadOnly property controls access level for current statement.

ZQuery adds some overhead, so if you don't need Dataset.Edit/Post methods, then use ZReadOnlyQuery.