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

Reply via email to