After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 772776 - VERY large queries (over 11000 fields in IN clause) slow down GnuCash
VERY large queries (over 11000 fields in IN clause) slow down GnuCash
Status: RESOLVED OBSOLETE
Product: GnuCash
Classification: Other
Component: Backend - SQL
2.6.10
Other Windows
: Normal enhancement
: ---
Assigned To: gnucash-core-maint
gnucash-core-maint
Depends on:
Blocks:
 
 
Reported: 2016-10-11 21:10 UTC by yenidai
Modified: 2018-06-29 23:51 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description yenidai 2016-10-11 21:10:10 UTC 
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.
Comment 1 yenidai 2016-10-11 21:21:56 UTC 
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.
Comment 2 John Ralls 2018-06-29 23:51:32 UTC 
GnuCash bug tracking has moved to a new Bugzilla host. The new URL for this bug is https://bugs.gnucash.org/show_bug.cgi?id=772776. Please continue processing the bug there and please update any external references or bookmarks.