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

Bug#686907: marked as done (snapshot db: add a multi-column index for the srcpkg table?)

Your message dated Thu, 19 Jan 2023 21:59:26 +0100
with message-id <284421db3ae1b2f206bfd672d7b6328cfef7d2bd.camel@cilg.org>
and subject line Re: snapshot db: add a multi-column index for the srcpkg table?
has caused the Debian Bug report #686907,
regarding snapshot db: add a multi-column index for the srcpkg table?
to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact owner@bugs.debian.org
immediately.)


-- 
686907: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=686907
Debian Bug Tracking System
Contact owner@bugs.debian.org with problems
--- Begin Message --- 
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.

-- 
bye,
pabs

http://wiki.debian.org/PaulWise

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


--- End Message ---
--- Begin Message --- 
On Fri, 07 Sep 2012 12:05:42 +0800 Paul Wise <pabs@debian.org> wrote:
> 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.


This has been fix in 2018 by adding a unique constraint over (name,
version) on srcpkg [1].

[1]: https://salsa.debian.org/snapshot-team/snapshot/-/commit/2e862c7821e46a5e2650a886e0d9093f6bce8fc3

-- 
Baptiste Beauplat

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


--- End Message ---
Reply to: