From 04b972005468db794529a732b764306c6d70fe97 Mon Sep 17 00:00:00 2001 From: Arne Georg Gleditsch Date: Thu, 29 Nov 2007 09:44:58 +0100 Subject: Sacrifice database integrity constraints for performance. The lxr datastore is mostly write-once as far as the individual tuples are concerned, and the foreign key reference can really hurt performance on large bulk insertions into big tables. --- lib/LXRng/Index/Pg.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'lib') diff --git a/lib/LXRng/Index/Pg.pm b/lib/LXRng/Index/Pg.pm index 7afb2a8..817d4c3 100644 --- a/lib/LXRng/Index/Pg.pm +++ b/lib/LXRng/Index/Pg.pm @@ -118,8 +118,8 @@ sub init_db { $dbh->do(qq{ create table ${pre}filereleases ( - id_rfile int references ${pre}revisions(id), - id_release int references ${pre}releases(id), + id_rfile int, + id_release int, primary key (id_rfile, id_release) ) }) or die($dbh->errstr); -- cgit v1.2.3