kine icon indicating copy to clipboard operation
kine copied to clipboard

Superfluous index definition

Open mcekovic opened this issue 2 years ago • 1 comments

Just scanning through repo and found superfluous index definition in most of the drivers:

CREATE INDEX IF NOT EXISTS kine_name_index ON kine (name), // Superfluous CREATE INDEX IF NOT EXISTS kine_name_id_index ON kine (name,id),

First index 'kine_name_index' is superfluous as RDBMSes can use second one 'kine_name_id_index' efficiently when searching just by 'name'. Removing this index can improve noticeably Kine insert performance and search by name performance would not be affected.

mcekovic avatar Feb 06 '22 08:02 mcekovic

@mcekovic we welcome community PRs!

dereknola avatar Jul 07 '22 16:07 dereknola