>> 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. Absolutely the same data in both databases, both definitely on CS. Table specifically created for testing with absolutely the same records and subsequent identical DML commands and commit intervals. Will repeat the same test later, now with re-configured RAID cache. Right now my wonderful wife is already tapping her foot to signal the start of a shopping tour. And, trust me, this can be more dangerous than an inefficient FB server ;-) ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 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/