>>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 null
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
liviuslivius liviusliv...@poczta.onet.pl [firebird-support] Tue, 28 May 2019 23:13:42 -0700
- Re: ODP: [fire... liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
- Re: ODP: ... danysch...@yahoo.com [firebird-support]
- Re: ODP: ... liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
- Re: ODP: ... liviuslivius liviusliv...@poczta.onet.pl [firebird-support]