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
    
  • [firebi... 'Mr. John' mr_joh...@yahoo.com [firebird-support]
    • Re... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
      • ... 'Mr. John' mr_joh...@yahoo.com [firebird-support]
        • ... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
          • ... 'Mr. John' mr_joh...@yahoo.com [firebird-support]
            • ... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
    • OD... Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]
      • ... 'Mr. John' mr_joh...@yahoo.com [firebird-support]
        • ... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
          • ... 'Mr. John' mr_joh...@yahoo.com [firebird-support]
            • ... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
              • ... 'Mr. John' mr_joh...@yahoo.com [firebird-support]
              • ... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
                • ... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
                • ... 'Mr. John' mr_joh...@yahoo.com [firebird-support]
                • ... DougC d...@moosemail.net [firebird-support]
        • ... Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]

Reply via email to