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 626677 - sqlite3 backend very slow (e.g. on creating 50 due txns from scheduled txn)
sqlite3 backend very slow (e.g. on creating 50 due txns from scheduled txn)
Status: RESOLVED OBSOLETE
Product: GnuCash
Classification: Other
Component: Backend - SQL
2.3.x
Other Linux
: Normal normal
: ---
Assigned To: gnucash-core-maint
gnucash-core-maint
Depends on:
Blocks: 722121
 
 
Reported: 2010-08-11 20:26 UTC by Juergen
Modified: 2018-06-29 22:42 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Juergen 2010-08-11 20:26:13 UTC 
when I set up a new scheduled transaction for a backward period, which results in maybe 50 due transactions, GC with sqlite needs about a minute to insert these into an almost empty file. The screen grays out, no signs of life. The transactions are entered correct.
When I do the same with the XML backend, it happens like lightning!
Comment 1 Wm 2016-03-26 23:19:56 UTC 
triage: suggest transitory and no longer appropriate, no real difference since SQLite and XML both in memory anyway these days and any inefficiencies probably local
Comment 2 John Ralls 2016-03-26 23:53:56 UTC 
(In reply to Wm from comment #1)
> triage: suggest transitory and no longer appropriate, no real difference
> since SQLite and XML both in memory anyway these days and any inefficiencies
> probably local

Maybe local, but the SQL backend writes disk immediately on every commit so it's not "both in memory".
Comment 3 John Ralls 2018-06-29 22:42:56 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=626677. Please continue processing the bug there and please update any external references or bookmarks.