Re: [firebird-support] Bad surprise on performance

2015-01-05 Thread Hugo Eyng hugoe...@msn.com [firebird-support]
Hello. FB 2.5.3 works (for me) on Win Server 2008 R2 Enterprise 64 bits, and others version of Win Server 2008 too. Dell R620 32GB RAM Intel Xeon E-2609. Hugo On 02/01/2015 22:08, André Knappstein knappst...@beta-eigenheim.de [firebird-support] wrote: Fascinating... I created a test table

Re: [firebird-support] Bad surprise on performance

2015-01-03 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi Andre, - get some sleep This is the key to find a solution, never optimize anything in a bad mood :) WinSrv2008R2 is a perfect Windows Server, when properly configured. Regards, Alexey

[firebird-support] Bad surprise on performance

2015-01-02 Thread André Knappstein knappst...@beta-eigenheim.de [firebird-support]
Hey! Happy new year to all! For me, it should have started with something great, new... FINALLY! The migration from FB 1.5 to 2.5 (trust me, I had reasons not to do it earlier). But now the old appications are all gone, and I can migrate. Seems there will be a delay. I migrated the

Re: [firebird-support] Bad surprise on performance

2015-01-02 Thread André Knappstein knappst...@beta-eigenheim.de [firebird-support]
Thank you for the prompt answer, Sean. But, no, I have read about this specific one. And though I am sure I did not fully understand about it yet, since my biggest database is only 1 GByte I *thought* this would not be a problem for me.

RE: [firebird-support] Bad surprise on performance

2015-01-02 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
Seems there will be a delay. I migrated the database from old hardware running 1.5.4 to new hardware running 2.5.3. Backup/Restore is about 4 times faster. Wow! But normal working is - at least - 50% slower sometimes worse. [Old] Server 2003 x86 no service packs Xeon with 4 GB RAM

RE: [firebird-support] Bad surprise on performance

2015-01-02 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
Thank you for the prompt answer, Sean. But, no, I have read about this specific one. And though I am sure I did not fully understand about it yet, since my biggest database is only 1 GByte I *thought* this would not be a problem for me. Do you still have access to old

Re: [firebird-support] Bad surprise on performance

2015-01-02 Thread André Knappstein knappst...@beta-eigenheim.de [firebird-support]
Fascinating... I created a test table on both old and new server to play with updates and inserts (~ 150.000 records) Performance with 2.5.3 x64 on Win2008 is constantly changing, but at best its some 8 seconds and worst even 2 minutes! Performance with 1.5.4 x86 on Win2003 is always about

Re: [firebird-support] Bad surprise on performance

2015-01-02 Thread André Knappstein knappst...@beta-eigenheim.de [firebird-support]
Yes, the old system is running. It *is* the current production system of our company and it looks like I'll be glad if it holds on a bit longer :-) Don't know the Crystal Disk Mark. Will check this out for sure! Was trying to get some clue from Process Explorer (the former SysInternals

Re: [firebird-support] Bad surprise on performance

2015-01-02 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 3-1-2015 00:14, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: [new] Server 2008 R2 x64 SP1 Xeon with 8 GB RAM (I will shortly add +8) Classic 2.5.3 x64 Raid 0 on 3 * 600 GB SAS Let me guess, you database is larger than 8GB (or 16GB in size)? The problem is not

Re: [firebird-support] Bad surprise on performance

2015-01-02 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]
LSSBcfs Your problem is the infamous Windows 64bit File Cache causes excessive Page File usage. Btw, afaik, 2.5.3 should not have this problem with the Windows cache. []s Carlos Firebird Performance in Detail - http://videos.firebirddevelopersday.com www.firebirdnews.org - www.FireBase.com.br