Author: eelco Date: Thu Aug 5 14:06:02 2010 New Revision: 22964 URL: https://svn.nixos.org/websvn/nix/?rev=22964&sc=1
Log: * Create some more indices on tables that have a foreign key reference to the Builds table. Otherwise deleting builds (e.g. when flushing the queue) is very slow. Modified: hydra/trunk/src/sql/hydra.sql Modified: hydra/trunk/src/sql/hydra.sql ============================================================================== --- hydra/trunk/src/sql/hydra.sql Thu Aug 5 13:39:08 2010 (r22963) +++ hydra/trunk/src/sql/hydra.sql Thu Aug 5 14:06:02 2010 (r22964) @@ -506,6 +506,8 @@ create index IndexCachedGitInputsOnHash on CachedGitInputs(uri, branch, sha256hash); create index IndexCachedGitInputsOnLastSeen on CachedGitInputs(uri, branch, lastSeen); create index IndexCachedSubversionInputsOnUriRevision on CachedSubversionInputs(uri, revision); +create index IndexJobsetEvalMembersOnBuild on JobsetEvalMembers(build); create index IndexJobsetInputAltsOnInput on JobsetInputAlts(project, jobset, input); create index IndexJobsetInputAltsOnJobset on JobsetInputAlts(project, jobset); create index IndexProjectsOnEnabled on Projects(enabled); +create index IndexReleaseMembersOnBuild on ReleaseMembers(build); _______________________________________________ nix-commits mailing list [email protected] http://mail.cs.uu.nl/mailman/listinfo/nix-commits
