Is there an ER Diagram and Data Dictionary?

[tarianjed]

@PaulHop

Duplicati’s database structure would benefit from some work. The work would improve the performance, reliability and maintainability of the application. I can commence this work, but I’ll only commence it if others support the work, I’d hate to waste my time if the work is never released. Would others support overall improvements to Duplicati’s database structure, database integrity, and query design?

As long as you track your work with a github issue so others can collaborate and prevent double work I have no issues.
This will have a pretty large code refactoring requirement which might also overlap with the push to update the code to .net 5 (.NET 5 Migration · GitHub).

If you read this forum thread you can learn from some of the research and work I have done so far:

DB Query Performance Testing, Fixes, and Maintainability

I have realized now my support post (Identified another slow query during backup) has expanded past the Support tag it is under so I am going to make this post to have a working thread for some of the stuff I brought up. I wanted to bring up a couple things I noticed while fixing my query performance issues and open a thread for general DB issues to be discussed. Indexes - I identified some indexes that basically solved most of the query performance issues I was experiencing on a large many f…