Thank you Dmitry. Seems I found the solution to the real problem parallel to your posting of the message (BBU failure report resetting cache parameters).
The difference on old hardware (2.9 - 3.2) seconds probably is due to inaccuracy in the very simple test methods. And, yes, nobody was currently working on the old hardware, but there still are some 400 fb_inet processes active, which probably added to the inaccuracy. ===================================================================== Ihre Nachricht: > 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 ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 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/
