Page 1 of 1
SmartOpen
Posted: 07.12.2005, 22:08
by zippo
What is the mean of the doSmartOpen option in the TZQuery component? I played a little, but see no difference in the behaviour of the application.
Is there any mini FAQ for Zeos?
Posted: 07.12.2005, 23:57
by btrewern
Don't see the option! What version of Zeos are you using?
Ben
Posted: 08.12.2005, 19:51
by gto
btrewern wrote:Don't see the option! What version of Zeos are you using?
Ben
CVS 13/10 have that option
anyway, I don't know what it does too
if the mod's can play with a mini-faq, I wish to know what ZSequence does!
Posted: 09.12.2005, 10:58
by zippo
True, the CVS from 13/10. Zeos team, help!
Posted: 15.12.2005, 14:17
by gto
Hey zippo, I've been looking the sources for that option..
The main diference between SmartOpen and not SmartOpen is the procedure used to fetch the data on the background.
The code actually is in ZDbcInterbase6Statement.pas
Using SmartOpen will fire the ExecutePrepared function.. otherwise, the ExecuteQueryPrepared is used...
I cannot figure out the main difference through the functions, but, for me, SmartOpen enabled is slightly faster.. maybe SmartOpen is some kind of andvanced FetchOnDemand option.
Well, technical comments would be great
[]'s
Update!!
Googling out and I find that:
Added doSmartOpen option to Dataset to allow executing DML statements by Open without throwing exception.
link to google cache
Posted: 18.12.2005, 08:45
by zippo
ahaaaa...
Thank you! I'll play a little to see what's the speed difference.