TOraSQL Strictupdate?

gezas · Post by **gezas** » Thu 15 Apr 2010 03:13

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

bork · Post by **bork** » Thu 15 Apr 2010 08:17

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.

gezas · Post by **gezas** » Thu 15 Apr 2010 23:03

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

bork · Post by **bork** » Fri 16 Apr 2010 08:46

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).