tree f490da25da6bc7b62eeb91f974885c2ed8dc1069
parent cc2d459520de4f6680a0e9e9356d014356bd4718
author Josef Cejka <jcejka@suse.de> 1659110705 -0400
committer Frank Ch. Eigler <fche@redhat.com> 1659110705 -0400
gpgsig -----BEGIN PGP SIGNATURE-----
 
 iQEzBAABCAAdFiEEXTgRb6TTp8x343jTfoNhASbcwugFAmLkBT0ACgkQfoNhASbc
 wujRhgf/UbbvCKQ31teQRaUVsB38yxeZ6HoI4EnKSHnUELBCrj7ciL3BjBf5Ghj3
 ZN8TECVk+61zQCxCfr9J0pK+jSX1F0XQsS4qkV7HUkl3sKQUvjhUPKtqNCdTbvEi
 DvEsMvVuHujY6DKGL+J844MftFc+yxBQ030TMhlGyO/GWpxz77/653lBbwyTx2XM
 JlEYe5aImK7Ac9O6g/Q8xHSr1jO/4hgPrQX31v8LykdOGuWVuYxvV6Ygn+8GWhdF
 EIhf/kAKyl9B1SBkh7wqSHnmRyrBUxq+Nvw5OsZIJ+QCPV3Kc5YnmXiQat1ov6gX
 ILACXtxmvfKqC3P9FDbS2rPnZQEKOw==
 =V6G7
 -----END PGP SIGNATURE-----

debuginfod: create indexes to speed up grooming

Create indexes on _r_de and _f_de tables
to speed up delete operations called by groom() function.

Primary keys of those tables are optimalized to search rows
by buildids so delete by file and mtime attributes
has to scan the whole table. On large database can single
delete query take minutes and grooming will be aborted
before completion by time limit.

New indexes are compatible with current sqlite schema.

Signed-off-by: Josef Cejka <jcejka@suse.de>