Closed bjk17 closed 8 years ago
Switch to PostgreSQL, see issue #16. It will boost performance.
This is irrelevant as the site is now hosted on a Intel NUC with modern Intel Hashwell processor (see https://blog.bjk.is/my-hobby-project.html#my-hobby-project). The performance issue on the Raspberry Pi was a mix of a very primitive processor and slow data interface.
Possible ways to optimize: -Do database alterations with BEGIN; and COMMIT; instead of multiple transactions
Compare performance with other machines runnings exact same code, such as Cubietruck.