Hi where have you run and got 0.078s?As I mentioned in my first post I run that query for 15 times for each sever FB,PG,mysql.tested from 2 different computers/internet connectionswhy PG and mysql works fine? PG is almost x40 times faster?
On Monday, March 4, 2019, 6:06:17 PM GMT+2, Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support] <firebird-support@yahoogroups.com> wrote: Hi. This is not Firebird issue. You must look into something between. For me first run is: Total execution time: 0.078s Second buffered is: Total execution time: 0.000s 3 seconds is really long time. There must be something involved between. 3 seconds on even 1RPM HDD 😉is also long.. Regards, Karol Bieniaszewski