03.01.2015 03:08, André Knappstein wrote: > > 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.
Are servers (especially the new one) loaded when you perform your tests? Execution time can sometimes vary in SS due to the GC policy but it cannot happen for CS, unless there are other queries running at the same time. > Query > ------------------------------------------------ > update X3058000 x > set > x.p3058_004n = (x.p3058_004n * 2) > > 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 These numbers suggest that either databases contain different data or you're comparing SS vs CS, possibly with some concurrent activity. Dmitry ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 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: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
