what a great tool! Using it since a few weeks and it's really nice! The only thing I recognized is, that it get's slower over time with more data. Scrolling get's a bit jerky and it loading times are a bit longer. I suppose that the SQLite is responsible for this? Or is this more a GUI-type of topic?
And will there be a way to backup/export the data and restore/import it in future?
Nice work, just donated some coffees ;-)
Given the amount of data ARC harvests, it will slow down to some extent over time, however, I'm trying to keep this within tolerable limits
I think I've eliminated most of the SQLite bottlenecks (mainly due to inefficient queries). I think all queries should now be sub-second.
There are two limits which are GUI related
- Screen initialisation - just because there are so many objects on the screen, it can take a few seconds to initialise a page the first time it is displayed. Once initialised, it should be quicker swapping between pages
- All the list view controls. These slow down with the data displayed. You'll see this being the worst in the leaderboards page, particular for a popular track like Monza where there are nearly 11000 rows, but this should only take a few seconds. If you hide columns you are not interested in, then rendering is quicker
On start-up, the app does various housekeeping tasks, making sure the database is in a good state and looking for and applying updates. Periodically (I think the default is once a month) it will perform database maintenance on start up (which can take a few minutes). You can adjust this in the settings page. Needless to say, the app will be quicker on an SDD than a HDD. Normally start up should only take about 10 seconds
If you opt in to the global ARC leaderboards, these can take a long time to download the first time (up to an hour given the number of people taking part). This can slow down the app while this is in progress. Note this pauses when you start a race. You can also manually pause it - see the help (F1) and search for Pausing Leaderboards.
If you experience slow downs (when the leaderboard update is not in progress), then let me know the specific problem, and I can look into it.
Finally, every session is backed up to a file (see the backups tab) - these can be re-imported if required. All the data is permanently stored in a database (see Backing up data in the help file). This database should regularly be backed up (or for ease it should be on a constantly synchronized folder such as OneDrive).
Finally, many thanks for the donation - it is much appreciated
