Den 13.02.2017 20:40, skrev Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support]:
> Hello, All.
>
> If I use prepared statement like this "update table set field1=?,
> field2=? where
> field3=?" for performance reasons, is there a way to update only some fields
> and leave
> other
> > Is that the real issue, you want to eliminate the "prepare" stage?
>
>"Prepare" does much more than just parsing of query and building plan. It
> also check for permissions and this stage cannot be cached.
Not if the cache was in the context of the current connection, so permissions
14.02.2017 16:21, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
wrote:
> If you are using UPDATE, then is it not reasonable to expect that you would
> know what the
> original values for of each field?
It is not reasonable: I have no way to know them. All I have at hand is new
>If I use prepared statement like this "update table set field1=?, field2=?
> where field3=?" for performance reasons, is there a way to update only
> some fields and leave other untouched without overhead of building
> separate queries on the fly or selecting old values with different