Baptiste Beauplat pushed to branch master at snapshot / snapshot
Commits: 6376a325 by Philipp Kern at 2024-11-19T14:58:32+01:00 Add DB version 24: adding indexes for node_id in symlink and directory tables Otherwise we were seeing full scans from readdir(). - - - - - ba691c00 by Baptiste Beauplat at 2024-11-19T20:09:00+01:00 Merge branch 'snapshot-db-upgrade' Signed-off-by: Baptiste Beauplat <[email protected]> - - - - - 1 changed file: - + db/upgrade_24.py Changes: ===================================== db/upgrade_24.py ===================================== @@ -0,0 +1,35 @@ +#!/usr/bin/python3 +# +# Copyright (c) 2009 Peter Palfrader +# +# Permission is hereby granted, free of charge, to any person obtaining a copy +# of this software and associated documentation files (the "Software"), to deal +# in the Software without restriction, including without limitation the rights +# to use, copy, modify, merge, publish, distribute, sublicense, and/or sell +# copies of the Software, and to permit persons to whom the Software is +# furnished to do so, subject to the following conditions: +# +# The above copyright notice and this permission notice shall be included in +# all copies or substantial portions of the Software. +# +# THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR +# IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, +# FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE +# AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER +# LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, +# OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE +# SOFTWARE. + +def upgrade(db): + db.execute(""" + CREATE INDEX IF NOT EXISTS + symlink_idx_node_id ON symlink USING btree (node_id); + CREATE INDEX IF NOT EXISTS + directory_idx_node_id ON directory USING btree (node_id); + """) + + db.execute("UPDATE config SET value='24' WHERE name='db_revision' AND value='23'") + +# vim:set et: +# vim:set ts=4: +# vim:set shiftwidth=4: View it on GitLab: https://salsa.debian.org/snapshot-team/snapshot/-/compare/1e3fdb21ab844e74785594cad61e5acc5a8ff3e0...ba691c00e2d488efedac7642b03dfb960cd5deb6 -- View it on GitLab: https://salsa.debian.org/snapshot-team/snapshot/-/compare/1e3fdb21ab844e74785594cad61e5acc5a8ff3e0...ba691c00e2d488efedac7642b03dfb960cd5deb6 You're receiving this email because of your account on salsa.debian.org.
