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.

1 files changed, 2 insertions, 2 deletions

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);