On 29/12/2018 10:10, Adriano dos Santos Fernandes wrote:
The cached in request value is now the timestamp with tz, then
localtimestamp requires a conversion.
That conversion requires to open ICU calendar to get the effective
displacement.
Please try to alter the session time zone to a displacement (set time
zone '-02:00') and see if the performance drop is equivalent.
What happens where we are still running the server as ONLY UTC? Which is
still the best method of handling any cross timezone data. Can the poor
quality tz stuff simply be disabled allowing correct offsets to be used
for everything?
--
Lester Caine - G8HFL
-----------------------------
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel