[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Bug#686907: snapshot db: add a multi-column index for the srcpkg table?

Package: snapshot.debian.org
Severity: wishlist

While profiling the derivatives census source package script, I noticed
that the index on the snapshots srcpkg table is by name only and I
wonder if a multi-column index on [name, version] would be a good idea?
The compare-source-package-list script currently always uses both name
and version in queries so this would probably speed up the checks that
discover which source package to diff against.



Attachment: signature.asc
Description: This is a digitally signed message part

Reply to: