|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|
Ok you use FB2.5. What is your server type superserver, classic or superclassic.
I never use installer only zip kits then i do not know which server type is default.
If you use superserver then default values are super-small and you do not benefit from cache. Increase page buffers. Without this, all your queries are so slow as your harddrive. As you know, RAM is magnitude faster.