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 <*> 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/
