Subject Odp: [firebird-support] Re: Speed issues
Author liviuslivius@poczta.onet.pl
Hi,

Yes i know that,
But if he have some permanent connection to this db, then is the chance that next day when he run some query, some data are already in cache. And with bigger cache, is then bigger chance to same data in cache.

I use permanent connection on my server, where data are accesed from web. Sometimes in the past i loose performance only because there was no permanent connection and cache was cleared.

Regards,
Karol Bieniaszewski

----- Reply message -----
Od: "&apos;Leyne, Sean&apos; Sean@... [firebird-support]" <firebird-support@yahoogroups.com>
Do: "firebird-support@yahoogroups.com" <firebird-support@yahoogroups.com>
Temat: [firebird-support] Re: Speed issues
Data: pon., lut 9, 2015 16:52


 

Karol,

> What is your cache settings

In this case, the answer won't really matter.

Zoran's complaint is about the first time the query is executed. In that case, nothing would be in cache and everything would still need to be loaded from disk.


Sean