https://bugs.kde.org/show_bug.cgi?id=353555
--- Comment #7 from jesse <jvap...@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 watching all bug changes.
