MensBeam
/
Arsse
3
1
Fork 0
Code Issues 24 Pull Requests Releases 28 Activity
Labels Milestones
New Issue

SQL queries are not optimal #135

Open
opened 6 years ago by jking · 1 comments
jking commented 6 years ago
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

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
jking added the
enhancement
 label 6 years ago
jking removed the due date 0000-12-31 6 years ago
jking modified the milestone from (deleted) to Future 6 years ago
jking commented 5 years ago
Poster
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/
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
arch
arch2
dbtest
getopt
master
microsub
phake
reader
redup
rpm
Labels
Apply labels
Clear labels
admin tools api bug documentation duplicate enhancement feature help wanted in progress internals invalid packaging question testing trivial wontfix
No Label admin tools api bug documentation duplicate enhancement feature help wanted in progress internals invalid packaging question testing trivial wontfix
Milestone
Set milestone
Clear milestone
No items
No Milestone
Future
Assignees
Assign users
Clear assignees
No Assignees
1 Participants
Notifications
Due Date

No due date set.

Dependencies

This issue currently doesn't have any dependencies.

Write Preview
Loading…
Cancel
Save
There is no content yet.
Delete Branch '%!s(MISSING)'

Deleting a branch is permanent. It CANNOT be undone. Continue?

No
Yes