W dniu 2016-08-18 10:01:17 użytkownik Molnár Attila <amol...@mve.hu> napisał: > Hi! > > I think timeout should depend on these independent factors : > - transaction parameters : RORC = false else true
why do you need to take different action for readonly transaction? If statement consume to much resources during time set in timeout why not stop it like in other transactions? > - first fetch : not possible at the timeout moment = true else false agree > - average fetch time (start to measure after the first fetch) : very i do not know if average fetch time is good here any fetch taking too much time should be treated as timeout > high (config) = true else fales > > and optionally (config) > - plan : has NATURAL on some table (config) = true else false disagree - plan natural can be better in many cases than index retrivial and have not correlation with timeouts feature regards, Karol Bieniaszewski ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
