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, Seanapos; s...@broadviewsoftware.com [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
