Page 1 of 1
TOraSQL Strictupdate?
Posted: Thu 15 Apr 2010 03:13
by gezas
Hi,
there is an option on TOraQuery
TOraQuery.Options.StrictUpdate
When this is true then the RowsAffected property is not calculated.
Is there an equivalent for TOraSQL?
Cheers
Geza
Posted: Thu 15 Apr 2010 08:17
by bork
Hello
TOraSQL doesn't have the TOraQuery.Options.StrictUpdate property and you cannot turn off the RowsAffected property calculation.
Tell us why do you want to turn off the RowsAffected property calculation and we will try to help you.
Posted: Thu 15 Apr 2010 23:03
by gezas
Thanks for the quick response
Our application has very heavy db access. We try to utilize all possible tweaks to increase the performance.
Normally we do not need the rowsaffected value and I was delighted to see that I can turn off it's calculation. However I realized that this is only possible with TOraQuery. To use TOraQuery is not an options as TOraSQL is much faster.
Geza
Senior V6 Software Engineer
Posted: Fri 16 Apr 2010 08:46
by bork
Oracle calculates RowsAffected at the server and sends its value to client in any case. TOraQuery and TOraSQL don't calculate this value, they take ready value from OCI and it doesn't take time at all (it is usual variable assignment).