| 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-28T14:33:15Z |
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.
Regards,
Karol Bieniaszewski