17.08.2016 22:07, Dimitry Sibiryakov wrote:
> 17.08.2016 20:44, Vlad Khorsun wrote:
>> - can't be greater than (non-zero) value at config
>
> I.e there is no way for DBA to make exceptions for some queries that are
> known to be
> good, but long, right?
Right. Smart DBA should set timeout value big enough to allow such "known
good" queries.
>> - timeout tracked since the moment of the execution start, i.e. timer is not
>> reset by the fetch() calls
>> - timeout timer is stopped when statement execution is finished - at the end
>> of
>> exec() method or when the fetch() returns last record
>
> I.e interactive Delphi application that fetch only really shown records
> will get error
> when user press "Down" key,
If user fetch one record per hour - yes, such application should be better
rewritten
> or DBA won't be able to use this feature on database which
> they are working with, at all, right?
DBA should decide what is more important for DB. Currently, DBA have no way
to control.
Vlad
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
