SQL queries are not optimal #135

New issue

Open

opened 2018-01-26 17:37:06 -05:00 by jking · 1 comment

jking commented

2018-01-26 17:37:06 -05:00

Owner

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

2018-01-26 17:37:06 -05:00

jking added the

enhancement

label

2018-01-26 17:37:06 -05:00

jking removed the due date 0000-12-31

2018-08-15 09:46:14 -04:00

jking modified the milestone from (deleted) to Future

2018-11-03 14:05:08 -04:00

jking commented

2019-02-13 11:42:12 -05:00

Author

Owner

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/

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/