[kmymoney] [Bug 353555] Database backend is much slower than standard kmy format

[jesse]

https://bugs.kde.org/show_bug.cgi?id=353555

--- Comment #7 from jesse <jvapr27 at yahoo.com> ---
I interpreted the question as attempting to use the sqlite database through
external programs. 

Interesting; Is there a reason why it uses the database as a file
save(recreates the tables and loads the data each time)? Was the intention to
allow users to query the database when KMY is not in use?

It is likely that the database does not have any built-in indexes.
https://database.guide/list-indexes-in-sqlite-database/
Can the OP or someone with a sqlite database see if that commands brings back a
list of indexes? 

I guess the next step would be to figure out if the KMY code recreates the
entire database tables or only truncate and reload the tables. If it recreates
the tables, and there no indexes, each time it would need to recreate indexes
too. If it only truncates the tables, then the users can create the indexes
they need for their custom external applications. Statistics on the database
may be needed to help the optimizer keep the database response times fast. 

jv

-- 
You are receiving this mail because:
You are the assignee for the bug.