Re: [Firebird-devel] MaxFileSystemCache (was Re: FB 2.1 64bit and memory usage ??)

[Adriano d. S. F. <adr...@uo...>]

Vlad Horsun escreveu:
>> Testing the new feature, I see a problem.
>>
>> Since we maintain the cache per-database, when all attachments are 
>> disconnected, we loose all the cache, causing very huge performance 
>> problems.
>>     
>
>     How it is related to the new feature ?
Not directly related, but with FS cache enabled, the OS caches even 
closed files.

This is big problem with FS cache disabled...

Imagine all users disconnect from application in the end of day and 
reconect again in the another day.

Just for example, I have a query that runs in 250 seconds when database 
is not cached, and 3 seconds when it is cached (i.e., run it again even 
if I close the server).


Adriano