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 the same, and always 2.9 - 3.2 seconds.
My next steps will be: - get some sleep - reduce example to a database with only this one testtable - install 2.5.3 on 2 other new servers (different RAIDs) and test there - test also with 2.5.3 CS x86, 2.5.3 SS x64/x86, 1.5.4 CS x86 - fire myself before presenting bill for new server to my boss unless I find a solution If somebody *KNOWS* for sure that Firebird just won't work on Server2008, or if someone knows for sure that it does, please drop a note. Query ------------------------------------------------ update X3058000 x set x.p3058_004n = (x.p3058_004n * 2) Plan ------------------------------------------------ PLAN (X NATURAL) Query Time (new Server)) ------------------------------------------------ Prepare : 0,00 ms Execute : 30.781,00 ms Avg fetch time: 0,00 ms Query Time (old Server) ------------------------------------------------ Prepare : 15,00 ms Execute : 3.110,00 ms Avg fetch time: 0,00 ms Memory (new Server) ------------------------------------------------ Current: 10.412.912 Max : 10.504.672 Buffers: 2.048 Memory (old Server) ------------------------------------------------ Current: 5.887.792 Max : 6.158.624 Buffers: 2.048 Operations (new Server) ------------------------------------------------ Read : 2.247 Writes : 5.960 Fetches: 2.476.240 Marks : 807.922 Operations (old Server) ------------------------------------------------ Read : 8.516 Writes : 6.084 Fetches: 1.602.243 Marks : 582.584 mit freundlichen Grüßen, ppa. André Knappstein EDV und Controlling ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH Hafenweg 4 59192 Bergkamen-Rünthe Telefon: +49 2389 9240 140 Telefax: +49 2389 9240 150 e-mail: [email protected] Amtsgericht Hamm Nr. B 420 Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus USt-IDNr.: DE 125215402 ===================================================================== Ihre Nachricht: > 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 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. > I already scanned the newsgroups and noticed that other users had the > same problem, but none of them seems to have found a good solution. > For me - being only a part time wannabe administrator - I really don't > have a clue where to start looking. > Here are some details of the 2 systems; if anybody can point me into a > direction where to look first it would be most welcome. > [Old] > Server 2003 x86 no service packs > Xeon with 4 GB RAM > Classic 1.5.4 (x86, of course) > Raid 0 on 2 * 500 GB SAS (though this is from memory, I should look it > up...) > [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 > In comparison to what I read from others, my databases are small. > Biggest database is some 1 GB only. > Bad performance on updates and inserts and extremely bad performance > on committing a big number of record changes (~ 150.000 updates). > Database has 4096 Page Size and 2048 buffers (which sounds like > setting for SS but I specifically set it higher to use more RAM > according to a hint from experts). > While testing the configuration, nobody is in the network. > Firebird runs on dedicated server (just windows and Firebird). > where to look? > mit freundlichen Grüßen, > ppa. André Knappstein > EDV und Controlling > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH > Hafenweg 4 > 59192 Bergkamen-Rünthe > Telefon: +49 2389 9240 140 > Telefax: +49 2389 9240 150 > e-mail: [email protected] > Amtsgericht Hamm Nr. B 420 > Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus > USt-IDNr.: DE 125215402 > ------------------------------------ > ------------------------------------ > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > Also search the knowledgebases at > http://www.ibphoenix.com/resources/documents/ > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > ------------------------------------ > Yahoo Groups Links ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
