Everything is slow as all hell when a download/update ranking cycle is running on my laptop, and the cycle itself is like an hour long. This could be much, much better.
Particularly:
- Locking - can we switch to a properly-multithreaded sqlite? Or just a real RDBMS? Locking is killing us
- DB Profiling - figure out database queries that could be easily optimized - some ranking queries are almost certainly very poorly planned
Everything is slow as all hell when a download/update ranking cycle is running on my laptop, and the cycle itself is like an hour long. This could be much, much better.
Particularly: