Check-in Number:
|
4840 | |
Date: |
2004-Nov-16 17:23:28 (local)
2004-Nov-16 16:23:28 (UTC) |
User: | rse |
Branch: | |
Comment: |
I'm not 100% sure but for 99% of certainty I think we should use smaller transactions: 1. it is unnecessary to be able to roll back such much, 2. the foreign key determination could be wrong?, 3. the whole crawling takes long and a transaction should not |
Tickets: |
|
Inspections: |
|
Files: |
|
ossp-pkg/quos/openpkg-rdf2sql.pl 1.5 -> 1.6
--- openpkg-rdf2sql.pl 2004/11/16 16:20:27 1.5
+++ openpkg-rdf2sql.pl 2004/11/16 16:23:28 1.6
@@ -80,8 +80,6 @@
" VALUES ((SELECT MAX(pk_id) FROM quos_package),?);"
);
-$db->begin_work();
-
&fetchrdfsrecursendump2db($starturl);
sub fetchrdfsrecursendump2db {
@@ -120,7 +118,7 @@
my $rd_url = $repo->{'rdf:resource'};
# store repository information
- #$db->begin_work();
+ $db->begin_work();
$sql->{-rdf}->execute($rd_url);
# iterate over all packages in a repository
@@ -171,12 +169,11 @@
sleep(1);
}
}
- #$db->commit();
+ $db->commit();
}
}
# commit and disconnect from database
-$db->commit();
$db->disconnect();
# temporary function for showing actual XML
|
|