OSSP CVS Repository

ossp - Check-in [4840]
Not logged in
[Honeypot]  [Browse]  [Home]  [Login]  [Reports
[Search]  [Ticket]  [Timeline
  [Patchset]  [Tagging/Branching

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     2 inserted, 5 deleted

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

CVSTrac 2.0.1