Ledger
Ledger copied to clipboard
Improve database performance
Improve database performance
Previous work
This PR is based on work from @PotatoPresident , which mainly improves database insertions, by batching actions.
Lookup improvements
- Improved lookup performance by using the previously introduced cache for conditions
- Adding indexes to columns used in conditions (
action_id
,object_id
,old_object_id
,source
andplayer_id
) - Adding a composed index of
x
,y
,z
andworld
, which helps in ledger inspect and range lookups - Removed the table joins for the count checking, because they are no longer necessary with the above changes and it gives a good performance improvement
Misc features
- Using the server user cache to lookup player uuids, to use them to lookup player conditions. This has the benefit of allowing case insensitive player names
- Added command suggestions to sources
Due to https://github.com/QuiltServerTools/Ledger/commit/581abac204fb8f72b9419012eb164eccafae64d3 (which was originally committed by @PotatoPresident (?)) this would require a ledger database addon update. (Because com.uchuhimo.konf
is no longer relocated. There might also be other incompatible changes)