| Subject | Re: ODP: [firebird-support] Query that was very fast under the oldest 2.5 versions are very slow under 2.5.8 or 2.5.9 |
|---|---|
| Author | liviuslivius |
| Post date | 2019-05-29T04:37:19Z |
>>I enabled in firebird.conf the parameter DefaultDbCachePages = 2048, >>but after that the performace was 1 minute slower.
Yes, i am talking about this param you can also set it indyvidually for database.
And your value is small. If your db pagesize is 16KB then cache in your case is only 32MB which is value of cache from windows 3.1 ;-) days? If yor page sise is 4KB than it is 8MB...
And about changed plan, it is not releated to this setting but this only increase visibility in your small cache settings.
Regards,
Karol Bieniaszewski