4 # Benchmark script for Steve's marc db schema
10 my $dbh=DBI->connect("dbi:mysql:kohabenchmark", 'youruserid', 'yourpassword');
16 ($max) || ($max=79998);
19 for ($i=0; $i<$count; $i++) {
20 ($bibid) || ($bibid=int(rand($max))+1);
22 ($print) && (print "BIBID: $bibid\n");
23 my $sth=$dbh->prepare("select tagid,tag,subfieldcode,subfieldvalue from marc_subfield_table where bibid=$bibid order by tagid,subfieldorder");
26 while (my ($tagid,$tag,$subfieldcode,$subfieldvalue) = $sth->fetchrow) {
27 if ($tag ne $lasttag) {
28 ($print) && (print " Tag: $tag\n");
31 ($print) && (print " $subfieldcode $subfieldvalue\n");