I use gnucash for years and I observed, that Gnucash began slow down a bit every time when I use it. I've checked MySQL database logs (it is my backend) and I observed, that a Gnucash create very large queries against database , ex. SELECT * FROM gnucash.splits WHERE guid IN ('fffe48649b5251b4782d3c8593041a57',..... + 11000 another guids) Why Gnucash cannot use subqueries ? A query SELECT * FROM gnucash.transactions gives me all these guids and only 7 others.
Start up time: 58 sec. Database mysql dump Size: 9MB Environment: Windows 7 x64, Intel iCore 7 2,8GHz, 8GB RAM, everything on SSD disk.
I rewrote most of the load queries in 3.x to use subqueries instead of huge lists of guids. It didn't produce a big speedup for local servers but I suppose it might for a slow network connection. See also bug 795753.
