The SQL queries currently employed were written with no thought to efficiency. They should be re-examined to possibly speed them up, particularly those dealing with articles
The SQL queries currently employed were written with no thought to efficiency. They should be re-examined to possibly speed them up, particularly those dealing with articles
jking
added this to the (deleted) milestone 6 years ago
Version 0.6.0 improved performance significantly by reformulating inefficient queries, and there's probably more still which can be done in that area.
Adding indices may also be in order, but my knowledge of how they work in practice is limited. A useful reference is here:
https://use-the-index-luke.com/
The SQL queries currently employed were written with no thought to efficiency. They should be re-examined to possibly speed them up, particularly those dealing with articles
Version 0.6.0 improved performance significantly by reformulating inefficient queries, and there's probably more still which can be done in that area.
Adding indices may also be in order, but my knowledge of how they work in practice is limited. A useful reference is here:
https://use-the-index-luke.com/