[firebird-support] Performance issues moving to new server with later Firebird version

2016-04-18 Thread mailgro...@murdochfl.com [firebird-support]
We have a 127GB Firebird database that was running on Windows Server 2008 x64 with 16GB of RAM and Firebird SuperClassic v2.5.2.26539. The database has a page size of 8192 and buffers of 6144, and ODS version 11.2. Due to time constraints I could not do a backup+restore on the new server, w

Re: [firebird-support] Performance issues moving to new server with later Firebird version

2016-04-19 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi Bob, In general, we recommend to apply the same configuration as at the old server (even if it looks not very good), and compare the performance - if there will be a problem, obviously it will be related with the new hardware/OS. If there will be the same performance, then you can tune fi

Re: [firebird-support] Performance issues moving to new server with later Firebird version

2016-04-19 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
Hi,   1. you buffer settings is low. you can simple calc numbers like page_size*buffer_Size*IFTHEN(Architecture=SUPERSERVER, 1, CONNECTIONS_NUMBER) +  Temp_Cache_Limit*CONNECTIONS_NUMBER i write from memory then someone can fix some mistakes 2. second what is your CPU usage when you compare this tw