From gmod-schema-admin@lists.sourceforge.net Mon Mar 3 09:28:28 2003 Return-Path: Received: from sunflower.bio.indiana.edu (sunflower.bio.indiana.edu [156.56.96.143] (may be forged)) by cricket.bio.indiana.edu (8.11.6+Sun/8.11.6) with ESMTP id h23ESS116845 for ; Mon, 3 Mar 2003 09:28:28 -0500 (EST) Received: from sc8-sf-list2.sourceforge.net (lists.sourceforge.net [66.35.250.206]) by sunflower.bio.indiana.edu (8.11.6+Sun/8.10.2) with ESMTP id h23ENkE00342 for ; Mon, 3 Mar 2003 09:23:46 -0500 (EST) Received: from sc8-sf-list1-b.sourceforge.net ([10.3.1.13] helo=sc8-sf-list1.sourceforge.net) by sc8-sf-list2.sourceforge.net with esmtp (Exim 3.31-VA-mm2 #1 (Debian)) id 18pqor-0008FX-00; Mon, 03 Mar 2003 06:21:29 -0800 Received: from mta4.srv.hcvlny.cv.net ([167.206.5.10]) by sc8-sf-list1.sourceforge.net with esmtp (Exim 3.31-VA-mm2 #1 (Debian)) id 18pqWz-0000R9-00 for ; Mon, 03 Mar 2003 06:03:01 -0800 Received: from asv20.srv.hcvlny.cv.net (asv20.srv.hcvlny.cv.net [167.206.5.174]) by mta4.srv.hcvlny.cv.net (iPlanet Messaging Server 5.2 HotFix 1.05 (built Nov 6 2002)) with ESMTP id <0HB60080DF0Q43@mta4.srv.hcvlny.cv.net> for gmod-schema@lists.sourceforge.net; Mon, 03 Mar 2003 09:02:51 -0500 (EST) Received: from kato.lsjs.org (ool-18bc35f9.dyn.optonline.net [24.188.53.249]) by asv20.srv.hcvlny.cv.net (8.12.6/8.12.5) with ESMTP id h23E1uvk022451 for ; Mon, 03 Mar 2003 09:01:57 -0500 (EST) From: Lincoln Stein To: gmod-schema@lists.sourceforge.net Reply-to: lstein@cshl.org Message-id: <200303030900.02210.lstein@cshl.org> Organization: Home MIME-version: 1.0 Content-type: multipart/mixed; boundary="Boundary_(ID_VQjQ5/woyabzdpmsMsrzWw)" User-Agent: KMail/1.5 Subject: [Gmod-schema] Benchmarking range query Sender: gmod-schema-admin@lists.sourceforge.net Errors-To: gmod-schema-admin@lists.sourceforge.net X-BeenThere: gmod-schema@lists.sourceforge.net X-Mailman-Version: 2.0.9-sf.net Precedence: bulk List-Help: List-Post: List-Subscribe: , List-Id: schema development for GMOD List-Unsubscribe: , List-Archive: Date: Mon, 03 Mar 2003 09:00:02 -0500 X-SpamBouncer: 1.5 (10/01/02) X-SBNote: From Admin X-SBNote: FROM_DAEMON/Listserv X-SBClass: Admin Status: RO Content-Length: 86948 --Boundary_(ID_VQjQ5/woyabzdpmsMsrzWw) Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7BIT Content-disposition: inline Hi All, I've been doing some benchmarking of MySQL vs PostgreSQL for the GBrowse canonical query, which is to fetch all features that overlap a particular range. The basic table looks like this: create table loc ( feature_id integer primary key, fseq_id varchar(10) not null, fstart integer not null, fend integer not null, fstrand integer not null default 0 ) and the basic query looks like this: select count(feature_id) from loc where fseq_id=$id and fend >= $start and fstart <= $end; This is an overlap query looking for features that intersect the range $start to $end. For simplicity, I insist that fstart= 24800000 and fstart <= 24805000; To perform the benchmarks, I fetched sequential 5000 bp ranges across each simulated chromosome, and then averaged the rows/second for ranges in the first, middle and last 10% of the chromosomal length. Higher numbers are better. Rows/second Method 1st 10% Middle 10% Last 10% Mysql nobin 92.6 14.4 8.4 Postgres nobin 100.4 122.0 98.8 Mysql bin 454.5 1041.7 1087.0 Postgres bin 2.0 2.1 2.1 The benchmark indicates that for the non-bin schema, PostgreSQL is able to manage about 100 rows per second; performance degrades very slightly in the middle of the range. For the same schema, MySQL has about the same performance for the very beginning of the chromosomal range, but suffers a dramatic 10-fold performance loss as it moves from the left of the chromosome to the right. When binning is added to the equation, MySQL sees an order-of-magnitude increase in speed, but Postgres slows down amazingly, and acts as though it isn't using the index at all (although EXPLAIN claims it is). I have tried a few variants on the binning scheme, but can't get the same speedup between non-binned and binned searches on PostgreSQL that I get with MySQL. Since PostgreSQL is faster than MySQL on the non-binned query, I would love to see it get the same speedup. A typical GBrowse screen contains several hundred features, and the number can easily rise into the thousands when viewing gapped alignments. So the 1000 rows/sec figure is about right. Can someone help? Enclosed are the following files: generate_benchmark.pl script to generate simulated genome generate_queries.pl script to generate the ranges that will be ` queried queries.txt query ranges for the benchmark load_benchmark_mysql_bin.pl loaders for simulated genome load_benchmark_mysql_nobin.pl load_benchmark_pg_bin.pl load_benchmark_pg_nobin.pl run_queries_mysql_bin.pl run and time the queries run_queries_mysql_nobin.pl run_queries_pg_bin.pl run_queries_pb_nobin.pl bin_mysql.txt raw output of query runners bin_pg.txt nobin_mysql.txt nobin_pg.txt summary.txt The simulated genome itself is big (18 meg) so if you want it you can download it from ftp://ftp.wormbase.org/pub/people/lincoln/modular_schema/benchmark_data.txt.gz Thanks in advance for any insights you can offer. Lincoln -- Lincoln Stein lstein@cshl.org Cold Spring Harbor Laboratory 1 Bungtown Road Cold Spring Harbor, NY 11724 (516) 367-8380 (voice) (516) 367-8389 (fax) --Boundary_(ID_VQjQ5/woyabzdpmsMsrzWw) Content-type: text/x-perl; charset=us-ascii; name=generate_benchmark.pl Content-transfer-encoding: 7BIT Content-disposition: attachment; filename=generate_benchmark.pl #!/usr/bin/perl use strict; # generate a bunch of features in format seq_id,start,end use constant ROWS => 2_000_000; # number of features use constant FEAT_SIZE => 200; # average size of a feature use constant SEQIDS => 6; # number of sequence reference points use constant RANGE_END => 25_000_000; # length of chromosomes my $feature_id = 0; my $count = 0; for (1..ROWS) { my $seq_id = sprintf("Chr%s",1+int(rand SEQIDS)); my $length = int(FEAT_SIZE/2 + rand FEAT_SIZE); my $start = int(rand RANGE_END); my $end = $start+$length; my $strand = int(rand 3) - 1; print join("\t",$seq_id,$start,$end,$strand),"\n"; } --Boundary_(ID_VQjQ5/woyabzdpmsMsrzWw) Content-type: text/x-perl; charset=us-ascii; name=generate_queries.pl Content-transfer-encoding: 7BIT Content-disposition: attachment; filename=generate_queries.pl #!/usr/bin/perl # generate the standard queries use constant STEP => 100_000; # number of queries to perform use constant QLENGTH => 5000; # average length of query use constant SEQIDS => 6; # number of sequence reference points use constant RANGE_END => 25_000_000; # length of chromosomes # measure a few queries from one end to another for (my $start = 0; $start <= RANGE_END - STEP; $start += STEP) { my $seq_id = sprintf("Chr%s",1+int(rand SEQIDS)); my $end = $start + QLENGTH; print join("\t",$seq_id,$start,$end),"\n"; } --Boundary_(ID_VQjQ5/woyabzdpmsMsrzWw) Content-type: text/x-perl; charset=us-ascii; name=load_benchmark_mysql_bin.pl Content-transfer-encoding: 7BIT Content-disposition: attachment; filename=load_benchmark_mysql_bin.pl #!/usr/bin/perl use strict; use DBI; use Bio::DB::GFF::Util::Binning; use constant MINBIN => 1000; @ARGV = 'benchmark_data.txt' unless @ARGV; my $dbh = DBI->connect('dbi:mysql:test') or die "Couldn't connect"; my $sth; $dbh->do('drop table binloc'); $dbh->do(<errstr; create table binloc ( feature_id int(11) primary key auto_increment, fseq_id varchar(10) not null, fstart int(10) unsigned not null, fend int(10) unsigned not null, fstrand tinyint(1) not null default 0, fbin double(20,6) not null, index(fseq_id,fbin,fstart,fend) ) END ; $sth = $dbh->prepare(<errstr; insert into binloc (fseq_id,fbin,fstart,fend,fstrand) values (?,?,?,?,?) END ; print STDERR "loading\n"; while (<>) { chomp; my($seqid,$start,$end,$strand) = split "\t"; my $bin = bin($start,$end,MINBIN); $sth->execute($seqid,$bin,$start,$end,$strand) or die $dbh->errstr; } $sth->finish; print STDERR "done\n"; --Boundary_(ID_VQjQ5/woyabzdpmsMsrzWw) Content-type: text/x-perl; charset=us-ascii; name=load_benchmark_mysql_nobin.pl Content-transfer-encoding: 7BIT Content-disposition: attachment; filename=load_benchmark_mysql_nobin.pl #!/usr/bin/perl use strict; use DBI; my $dbh = DBI->connect('dbi:mysql:test') or die "Couldn't connect"; my $sth; $dbh->do('drop table loc'); $dbh->do(<errstr; create table loc ( feature_id int(11) primary key auto_increment, fseq_id varchar(10) not null, fstart int(10) unsigned not null, fend int(10) unsigned not null, fstrand tinyint(1) not null default 0, key location(fseq_id,fstart,fend) ) END ; $sth = $dbh->prepare(<errstr; insert into loc (fseq_id,fstart,fend,fstrand) values (?,?,?,?) END ; print STDERR "loading\n"; while (<>) { chomp; my($seqid,$start,$end,$strand) = split "\t"; $sth->execute($seqid,$start,$end,$strand) or die $dbh->errstr; } $sth->finish; print STDERR "done\n"; --Boundary_(ID_VQjQ5/woyabzdpmsMsrzWw) Content-type: text/x-perl; charset=us-ascii; name=load_benchmark_pg_bin.pl Content-transfer-encoding: 7BIT Content-disposition: attachment; filename=load_benchmark_pg_bin.pl #!/usr/bin/perl use strict; use DBI; use Bio::DB::GFF::Util::Binning; use constant MINBIN => 1000; @ARGV = 'benchmark_data.txt' unless @ARGV; my $dbh = DBI->connect('dbi:Pg:dbname=test', ) or die "Couldn't connect"; my $sth; $dbh->do('drop table binloc'); $dbh->do(<errstr; create table binloc ( feature_id integer primary key, fseq_id varchar(10) not null, fstart integer not null, fend integer not null, fstrand integer not null default 0, fbin numeric(20,6) not null ) END ; $dbh->{AutoCommit} = 0; $sth = $dbh->prepare(<errstr; insert into binloc (feature_id,fseq_id,fbin,fstart,fend,fstrand) values (?,?,?,?,?,?) END ; print STDERR "loading\n"; my $fid = 0; while (<>) { chomp; my($seqid,$start,$end,$strand) = split "\t"; my $bin = bin($start,$end,MINBIN); $sth->execute($fid++,$seqid,$bin,$start,$end,$strand) or die $dbh->errstr; print STDERR "$fid loaded\r" if $fid % 1000 == 0; } $sth->finish; $dbh->commit; print STDERR "done. Reindexing....\n"; $dbh->do('create index binloc_location on binloc(fseq_id,fbin,fstart,fend)') or die $dbh->errstr; $dbh->disconnect; --Boundary_(ID_VQjQ5/woyabzdpmsMsrzWw) Content-type: text/x-perl; charset=us-ascii; name=load_benchmark_pg_nobin.pl Content-transfer-encoding: 7BIT Content-disposition: attachment; filename=load_benchmark_pg_nobin.pl #!/usr/bin/perl use strict; use DBI; my $dbh = DBI->connect('dbi:Pg:dbname=test') or die "Couldn't connect"; my $sth; @ARGV = 'benchmark_data.txt' unless @ARGV; $dbh->do('drop table loc'); $dbh->do(<errstr; create table loc ( feature_id integer primary key, fseq_id varchar(10) not null, fstart integer not null, fend integer not null, fstrand integer not null default 0 ) END ; $dbh->{AutoCommit} = 0; $sth = $dbh->prepare(<errstr; insert into loc (feature_id,fseq_id,fstart,fend,fstrand) values (?,?,?,?,?) END ; print STDERR "loading\n"; my $fid = 0; while (<>) { chomp; my($seqid,$start,$end,$strand) = split "\t"; $sth->execute($fid++,$seqid,$start,$end,$strand) or die $dbh->errstr; print STDERR "$fid loaded\r" if $fid % 1000 == 0; } $sth->finish; $dbh->commit; # make the index now $dbh->do('create index location on loc(fseq_id,fstart,fend)'); print STDERR "done\n"; --Boundary_(ID_VQjQ5/woyabzdpmsMsrzWw) Content-type: text/plain; charset=us-ascii; name=queries.txt Content-transfer-encoding: 7BIT Content-disposition: attachment; filename=queries.txt Chr2 0 5000 Chr1 100000 105000 Chr1 200000 205000 Chr2 300000 305000 Chr1 400000 405000 Chr1 500000 505000 Chr4 600000 605000 Chr5 700000 705000 Chr2 800000 805000 Chr5 900000 905000 Chr5 1000000 1005000 Chr2 1100000 1105000 Chr1 1200000 1205000 Chr5 1300000 1305000 Chr5 1400000 1405000 Chr5 1500000 1505000 Chr3 1600000 1605000 Chr2 1700000 1705000 Chr5 1800000 1805000 Chr2 1900000 1905000 Chr3 2000000 2005000 Chr5 2100000 2105000 Chr6 2200000 2205000 Chr2 2300000 2305000 Chr4 2400000 2405000 Chr5 2500000 2505000 Chr6 2600000 2605000 Chr2 2700000 2705000 Chr3 2800000 2805000 Chr5 2900000 2905000 Chr2 3000000 3005000 Chr4 3100000 3105000 Chr5 3200000 3205000 Chr5 3300000 3305000 Chr1 3400000 3405000 Chr2 3500000 3505000 Chr6 3600000 3605000 Chr5 3700000 3705000 Chr6 3800000 3805000 Chr5 3900000 3905000 Chr3 4000000 4005000 Chr1 4100000 4105000 Chr2 4200000 4205000 Chr2 4300000 4305000 Chr5 4400000 4405000 Chr6 4500000 4505000 Chr6 4600000 4605000 Chr4 4700000 4705000 Chr2 4800000 4805000 Chr3 4900000 4905000 Chr3 5000000 5005000 Chr3 5100000 5105000 Chr2 5200000 5205000 Chr1 5300000 5305000 Chr3 5400000 5405000 Chr2 5500000 5505000 Chr6 5600000 5605000 Chr2 5700000 5705000 Chr1 5800000 5805000 Chr1 5900000 5905000 Chr6 6000000 6005000 Chr2 6100000 6105000 Chr4 6200000 6205000 Chr2 6300000 6305000 Chr3 6400000 6405000 Chr4 6500000 6505000 Chr4 6600000 6605000 Chr4 6700000 6705000 Chr6 6800000 6805000 Chr2 6900000 6905000 Chr3 7000000 7005000 Chr4 7100000 7105000 Chr4 7200000 7205000 Chr5 7300000 7305000 Chr5 7400000 7405000 Chr1 7500000 7505000 Chr1 7600000 7605000 Chr4 7700000 7705000 Chr5 7800000 7805000 Chr3 7900000 7905000 Chr2 8000000 8005000 Chr3 8100000 8105000 Chr4 8200000 8205000 Chr1 8300000 8305000 Chr6 8400000 8405000 Chr1 8500000 8505000 Chr5 8600000 8605000 Chr3 8700000 8705000 Chr4 8800000 8805000 Chr3 8900000 8905000 Chr1 9000000 9005000 Chr1 9100000 9105000 Chr1 9200000 9205000 Chr1 9300000 9305000 Chr1 9400000 9405000 Chr3 9500000 9505000 Chr6 9600000 9605000 Chr4 9700000 9705000 Chr3 9800000 9805000 Chr5 9900000 9905000 Chr1 10000000 10005000 Chr3 10100000 10105000 Chr1 10200000 10205000 Chr5 10300000 10305000 Chr3 10400000 10405000 Chr5 10500000 10505000 Chr6 10600000 10605000 Chr5 10700000 10705000 Chr1 10800000 10805000 Chr3 10900000 10905000 Chr5 11000000 11005000 Chr6 11100000 11105000 Chr2 11200000 11205000 Chr1 11300000 11305000 Chr2 11400000 11405000 Chr3 11500000 11505000 Chr6 11600000 11605000 Chr3 11700000 11705000 Chr1 11800000 11805000 Chr4 11900000 11905000 Chr6 12000000 12005000 Chr4 12100000 12105000 Chr2 12200000 12205000 Chr2 12300000 12305000 Chr4 12400000 12405000 Chr3 12500000 12505000 Chr1 12600000 12605000 Chr1 12700000 12705000 Chr6 12800000 12805000 Chr3 12900000 12905000 Chr6 13000000 13005000 Chr2 13100000 13105000 Chr1 13200000 13205000 Chr5 13300000 13305000 Chr6 13400000 13405000 Chr4 13500000 13505000 Chr5 13600000 13605000 Chr6 13700000 13705000 Chr6 13800000 13805000 Chr4 13900000 13905000 Chr4 14000000 14005000 Chr6 14100000 14105000 Chr4 14200000 14205000 Chr5 14300000 14305000 Chr5 14400000 14405000 Chr5 14500000 14505000 Chr5 14600000 14605000 Chr5 14700000 14705000 Chr6 14800000 14805000 Chr5 14900000 14905000 Chr4 15000000 15005000 Chr1 15100000 15105000 Chr4 15200000 15205000 Chr2 15300000 15305000 Chr1 15400000 15405000 Chr5 15500000 15505000 Chr6 15600000 15605000 Chr1 15700000 15705000 Chr6 15800000 15805000 Chr3 15900000 15905000 Chr1 16000000 16005000 Chr3 16100000 16105000 Chr4 16200000 16205000 Chr3 16300000 16305000 Chr4 16400000 16405000 Chr3 16500000 16505000 Chr4 16600000 16605000 Chr6 16700000 16705000 Chr5 16800000 16805000 Chr2 16900000 16905000 Chr1 17000000 17005000 Chr1 17100000 17105000 Chr3 17200000 17205000 Chr6 17300000 17305000 Chr6 17400000 17405000 Chr3 17500000 17505000 Chr2 17600000 17605000 Chr1 17700000 17705000 Chr3 17800000 17805000 Chr2 17900000 17905000 Chr6 18000000 18005000 Chr1 18100000 18105000 Chr3 18200000 18205000 Chr1 18300000 18305000 Chr2 18400000 18405000 Chr6 18500000 18505000 Chr2 18600000 18605000 Chr2 18700000 18705000 Chr5 18800000 18805000 Chr5 18900000 18905000 Chr3 19000000 19005000 Chr6 19100000 19105000 Chr2 19200000 19205000 Chr4 19300000 19305000 Chr5 19400000 19405000 Chr5 19500000 19505000 Chr6 19600000 19605000 Chr4 19700000 19705000 Chr4 19800000 19805000 Chr5 19900000 19905000 Chr3 20000000 20005000 Chr3 20100000 20105000 Chr1 20200000 20205000 Chr2 20300000 20305000 Chr6 20400000 20405000 Chr5 20500000 20505000 Chr4 20600000 20605000 Chr3 20700000 20705000 Chr4 20800000 20805000 Chr1 20900000 20905000 Chr1 21000000 21005000 Chr4 21100000 21105000 Chr5 21200000 21205000 Chr6 21300000 21305000 Chr2 21400000 21405000 Chr5 21500000 21505000 Chr4 21600000 21605000 Chr3 21700000 21705000 Chr4 21800000 21805000 Chr4 21900000 21905000 Chr4 22000000 22005000 Chr2 22100000 22105000 Chr6 22200000 22205000 Chr5 22300000 22305000 Chr1 22400000 22405000 Chr1 22500000 22505000 Chr6 22600000 22605000 Chr3 22700000 22705000 Chr6 22800000 22805000 Chr2 22900000 22905000 Chr2 23000000 23005000 Chr2 23100000 23105000 Chr1 23200000 23205000 Chr6 23300000 23305000 Chr3 23400000 23405000 Chr6 23500000 23505000 Chr5 23600000 23605000 Chr2 23700000 23705000 Chr6 23800000 23805000 Chr2 23900000 23905000 Chr6 24000000 24005000 Chr3 24100000 24105000 Chr2 24200000 24205000 Chr2 24300000 24305000 Chr2 24400000 24405000 Chr2 24500000 24505000 Chr6 24600000 24605000 Chr1 24700000 24705000 Chr4 24800000 24805000 Chr6 24900000 24905000 --Boundary_(ID_VQjQ5/woyabzdpmsMsrzWw) Content-type: text/x-perl; charset=us-ascii; name=run_queries_mysql_bin.pl Content-transfer-encoding: 7BIT Content-disposition: attachment; filename=run_queries_mysql_bin.pl #!/usr/bin/perl use strict; use DBI; use Time::HiRes qw(time); use Bio::DB::GFF::Util::Binning; # this is the smallest bin (1 K) use constant MINBIN => 1000; # this is the largest that any feature can be (1 Mb) use constant MAXBIN => 1_000_000; @ARGV = 'queries.txt' unless @ARGV; my $dbh = DBI->connect('dbi:mysql:test') or die "Couldn't connect"; while (<>) { chomp; my ($seq_id,$start,$end) = split /\s+/; my $time = time; my $bin_query = bin_query($dbh,$start,$end); my $query = <= ? and fstart <= ? END ; my $sth = $dbh->prepare($query) or die $dbh->errstr; $sth->execute($seq_id,$start,$end); my $rows = $sth->rows; my $elapsed = time-$time; print "$seq_id:$start..$end\t$rows rows in ",sprintf("%4.3f seconds, %4.3f sec/row\n",$elapsed,$elapsed/$rows); $sth->finish; } $dbh->disconnect; sub bin_query { my $dbh = shift; my ($start,$end) = @_; my ($query,@args); $start = 0 unless defined $start; $end = MAXBIN unless defined $end; my @bins; my $minbin = MINBIN; my $maxbin = MAXBIN; my $tier = $maxbin; while ($tier >= $minbin) { my ($tier_start,$tier_end) = (bin_bot($tier,$start),bin_top($tier,$end)); if ($tier_start == $tier_end) { push @bins,"fbin=$tier_start"; } else { push @bins,"fbin between $tier_start and $tier_end"; } $tier /= 10; } $query = join("\n\t OR ",@bins); $query; } --Boundary_(ID_VQjQ5/woyabzdpmsMsrzWw) Content-type: text/x-perl; charset=us-ascii; name=run_queries_mysql_nobin.pl Content-transfer-encoding: 7BIT Content-disposition: attachment; filename=run_queries_mysql_nobin.pl #!/usr/bin/perl use strict; use DBI; use Time::HiRes qw(time); @ARGV = 'queries.txt' unless @ARGV; my $dbh = DBI->connect('dbi:mysql:test') or die "Couldn't connect"; # canonical overlaps query my $sth = $dbh->prepare(<= ? and fstart <= ? END ; while (<>) { chomp; my ($seq_id,$start,$end) = split /\s+/; my $time = time; $sth->execute($seq_id,$start,$end); my $rows = $sth->rows; my $elapsed = time-$time; print "$seq_id:$start..$end\t$rows rows in ",sprintf("%4.3f seconds, %4.3f sec/row\n",$elapsed,$elapsed/$rows); } $sth->finish; $dbh->disconnect; --Boundary_(ID_VQjQ5/woyabzdpmsMsrzWw) Content-type: text/x-perl; charset=us-ascii; name=run_queries_pg_bin.pl Content-transfer-encoding: 7BIT Content-disposition: attachment; filename=run_queries_pg_bin.pl #!/usr/bin/perl use strict; use DBI; use Time::HiRes qw(time); use Bio::DB::GFF::Util::Binning; # this is the smallest bin (1 K) use constant MINBIN => 1000; # this is the largest that any feature can be (1 Mb) use constant MAXBIN => 1_000_000; @ARGV = 'queries.txt' unless @ARGV; my $dbh = DBI->connect('dbi:Pg:dbname=test') or die "Couldn't connect"; while (<>) { chomp; my ($seq_id,$start,$end) = split /\s+/; my $time = time; my $bin_query = bin_query($dbh,$start,$end); my $query = <= ? and fstart <= ? END ; my $sth = $dbh->prepare($query) or die $dbh->errstr; $sth->execute($seq_id,$start,$end); my $rows = $sth->rows; my $elapsed = time-$time; print "$seq_id:$start..$end\t$rows rows in ",sprintf("%4.3f seconds, %4.3f sec/row\n",$elapsed,$elapsed/$rows); $sth->finish; } $dbh->disconnect; sub bin_query { my $dbh = shift; my ($start,$end) = @_; my ($query,@args); $start = 0 unless defined $start; $end = MAXBIN unless defined $end; my @bins; my $minbin = MINBIN; my $maxbin = MAXBIN; my $tier = $maxbin; while ($tier >= $minbin) { my ($tier_start,$tier_end) = (bin_bot($tier,$start),bin_top($tier,$end)); if ($tier_start == $tier_end) { push @bins,"fbin=$tier_start"; } else { push @bins,"fbin between $tier_start and $tier_end"; } $tier /= 10; } $query = join("\n\t OR ",@bins); $query; } --Boundary_(ID_VQjQ5/woyabzdpmsMsrzWw) Content-type: text/x-perl; charset=us-ascii; name=run_queries_pg_nobin.pl Content-transfer-encoding: 7BIT Content-disposition: attachment; filename=run_queries_pg_nobin.pl #!/usr/bin/perl use strict; use DBI; use Time::HiRes qw(time); @ARGV = 'queries.txt' unless @ARGV; my $dbh = DBI->connect('dbi:Pg:dbname=test') or die "Couldn't connect"; # canonical overlaps query my $sth = $dbh->prepare(<= ? and fstart <= ? END ; while (<>) { chomp; my ($seq_id,$start,$end) = split /\s+/; my $time = time; $sth->execute($seq_id,$start,$end); my $rows = $sth->rows; my $elapsed = time-$time; print "$seq_id:$start..$end\t$rows rows in ",sprintf("%4.3f seconds, %4.3f sec/row\n",$elapsed,$elapsed/$rows); } $sth->finish; $dbh->disconnect; --Boundary_(ID_VQjQ5/woyabzdpmsMsrzWw) Content-type: text/plain; charset=us-ascii; name=bin_mysql.txt Content-transfer-encoding: 7BIT Content-disposition: attachment; filename=bin_mysql.txt Chr2:0..5000 76 rows in 0.024 seconds, 0.000 sec/row Chr1:100000..105000 66 rows in 0.309 seconds, 0.005 sec/row Chr1:200000..205000 80 rows in 0.144 seconds, 0.002 sec/row Chr2:300000..305000 70 rows in 0.179 seconds, 0.003 sec/row Chr1:400000..405000 67 rows in 0.148 seconds, 0.002 sec/row Chr1:500000..505000 55 rows in 0.119 seconds, 0.002 sec/row Chr4:600000..605000 67 rows in 0.256 seconds, 0.004 sec/row Chr5:700000..705000 66 rows in 0.243 seconds, 0.004 sec/row Chr2:800000..805000 77 rows in 0.143 seconds, 0.002 sec/row Chr5:900000..905000 72 rows in 0.116 seconds, 0.002 sec/row Chr5:1000000..1005000 67 rows in 0.071 seconds, 0.001 sec/row Chr2:1100000..1105000 53 rows in 0.078 seconds, 0.001 sec/row Chr1:1200000..1205000 72 rows in 0.543 seconds, 0.008 sec/row Chr5:1300000..1305000 84 rows in 0.276 seconds, 0.003 sec/row Chr5:1400000..1405000 72 rows in 0.070 seconds, 0.001 sec/row Chr5:1500000..1505000 74 rows in 0.043 seconds, 0.001 sec/row Chr3:1600000..1605000 66 rows in 0.113 seconds, 0.002 sec/row Chr2:1700000..1705000 72 rows in 0.101 seconds, 0.001 sec/row Chr5:1800000..1805000 60 rows in 0.102 seconds, 0.002 sec/row Chr2:1900000..1905000 68 rows in 0.064 seconds, 0.001 sec/row Chr3:2000000..2005000 72 rows in 0.107 seconds, 0.001 sec/row Chr5:2100000..2105000 72 rows in 0.127 seconds, 0.002 sec/row Chr6:2200000..2205000 70 rows in 0.173 seconds, 0.002 sec/row Chr2:2300000..2305000 74 rows in 0.069 seconds, 0.001 sec/row Chr4:2400000..2405000 77 rows in 0.149 seconds, 0.002 sec/row Chr5:2500000..2505000 73 rows in 0.113 seconds, 0.002 sec/row Chr6:2600000..2605000 77 rows in 0.108 seconds, 0.001 sec/row Chr2:2700000..2705000 66 rows in 0.094 seconds, 0.001 sec/row Chr3:2800000..2805000 60 rows in 0.083 seconds, 0.001 sec/row Chr5:2900000..2905000 70 rows in 0.125 seconds, 0.002 sec/row Chr2:3000000..3005000 68 rows in 0.105 seconds, 0.002 sec/row Chr4:3100000..3105000 74 rows in 0.088 seconds, 0.001 sec/row Chr5:3200000..3205000 61 rows in 0.133 seconds, 0.002 sec/row Chr5:3300000..3305000 82 rows in 0.126 seconds, 0.002 sec/row Chr1:3400000..3405000 66 rows in 0.101 seconds, 0.002 sec/row Chr2:3500000..3505000 64 rows in 0.117 seconds, 0.002 sec/row Chr6:3600000..3605000 81 rows in 0.138 seconds, 0.002 sec/row Chr5:3700000..3705000 67 rows in 0.075 seconds, 0.001 sec/row Chr6:3800000..3805000 70 rows in 0.110 seconds, 0.002 sec/row Chr5:3900000..3905000 69 rows in 0.209 seconds, 0.003 sec/row Chr3:4000000..4005000 55 rows in 0.087 seconds, 0.002 sec/row Chr1:4100000..4105000 66 rows in 0.122 seconds, 0.002 sec/row Chr2:4200000..4205000 60 rows in 0.126 seconds, 0.002 sec/row Chr2:4300000..4305000 64 rows in 0.050 seconds, 0.001 sec/row Chr5:4400000..4405000 64 rows in 0.134 seconds, 0.002 sec/row Chr6:4500000..4505000 55 rows in 0.080 seconds, 0.001 sec/row Chr6:4600000..4605000 83 rows in 0.073 seconds, 0.001 sec/row Chr4:4700000..4705000 75 rows in 0.098 seconds, 0.001 sec/row Chr2:4800000..4805000 68 rows in 0.073 seconds, 0.001 sec/row Chr3:4900000..4905000 65 rows in 0.092 seconds, 0.001 sec/row Chr3:5000000..5005000 71 rows in 0.097 seconds, 0.001 sec/row Chr3:5100000..5105000 64 rows in 0.111 seconds, 0.002 sec/row Chr2:5200000..5205000 58 rows in 0.097 seconds, 0.002 sec/row Chr1:5300000..5305000 69 rows in 0.136 seconds, 0.002 sec/row Chr3:5400000..5405000 66 rows in 0.103 seconds, 0.002 sec/row Chr2:5500000..5505000 70 rows in 0.099 seconds, 0.001 sec/row Chr6:5600000..5605000 70 rows in 0.111 seconds, 0.002 sec/row Chr2:5700000..5705000 59 rows in 0.113 seconds, 0.002 sec/row Chr1:5800000..5805000 69 rows in 0.147 seconds, 0.002 sec/row Chr1:5900000..5905000 79 rows in 0.176 seconds, 0.002 sec/row Chr6:6000000..6005000 57 rows in 0.086 seconds, 0.002 sec/row Chr2:6100000..6105000 71 rows in 0.103 seconds, 0.001 sec/row Chr4:6200000..6205000 92 rows in 0.041 seconds, 0.000 sec/row Chr2:6300000..6305000 80 rows in 0.062 seconds, 0.001 sec/row Chr3:6400000..6405000 85 rows in 0.084 seconds, 0.001 sec/row Chr4:6500000..6505000 87 rows in 0.076 seconds, 0.001 sec/row Chr4:6600000..6605000 70 rows in 0.052 seconds, 0.001 sec/row Chr4:6700000..6705000 68 rows in 0.183 seconds, 0.003 sec/row Chr6:6800000..6805000 64 rows in 0.118 seconds, 0.002 sec/row Chr2:6900000..6905000 75 rows in 0.078 seconds, 0.001 sec/row Chr3:7000000..7005000 72 rows in 0.086 seconds, 0.001 sec/row Chr4:7100000..7105000 67 rows in 0.069 seconds, 0.001 sec/row Chr4:7200000..7205000 66 rows in 0.063 seconds, 0.001 sec/row Chr5:7300000..7305000 73 rows in 0.216 seconds, 0.003 sec/row Chr5:7400000..7405000 68 rows in 0.073 seconds, 0.001 sec/row Chr1:7500000..7505000 69 rows in 0.060 seconds, 0.001 sec/row Chr1:7600000..7605000 47 rows in 0.082 seconds, 0.002 sec/row Chr4:7700000..7705000 65 rows in 0.076 seconds, 0.001 sec/row Chr5:7800000..7805000 63 rows in 0.044 seconds, 0.001 sec/row Chr3:7900000..7905000 75 rows in 0.076 seconds, 0.001 sec/row Chr2:8000000..8005000 69 rows in 0.055 seconds, 0.001 sec/row Chr3:8100000..8105000 70 rows in 0.093 seconds, 0.001 sec/row Chr4:8200000..8205000 69 rows in 0.094 seconds, 0.001 sec/row Chr1:8300000..8305000 76 rows in 0.115 seconds, 0.002 sec/row Chr6:8400000..8405000 81 rows in 0.072 seconds, 0.001 sec/row Chr1:8500000..8505000 56 rows in 0.085 seconds, 0.002 sec/row Chr5:8600000..8605000 70 rows in 0.077 seconds, 0.001 sec/row Chr3:8700000..8705000 67 rows in 0.052 seconds, 0.001 sec/row Chr4:8800000..8805000 61 rows in 0.005 seconds, 0.000 sec/row Chr3:8900000..8905000 80 rows in 0.083 seconds, 0.001 sec/row Chr1:9000000..9005000 72 rows in 0.046 seconds, 0.001 sec/row Chr1:9100000..9105000 71 rows in 0.184 seconds, 0.003 sec/row Chr1:9200000..9205000 80 rows in 0.049 seconds, 0.001 sec/row Chr1:9300000..9305000 60 rows in 0.083 seconds, 0.001 sec/row Chr1:9400000..9405000 77 rows in 0.049 seconds, 0.001 sec/row Chr3:9500000..9505000 51 rows in 0.048 seconds, 0.001 sec/row Chr6:9600000..9605000 72 rows in 0.080 seconds, 0.001 sec/row Chr4:9700000..9705000 59 rows in 0.033 seconds, 0.001 sec/row Chr3:9800000..9805000 67 rows in 0.052 seconds, 0.001 sec/row Chr5:9900000..9905000 67 rows in 0.060 seconds, 0.001 sec/row Chr1:10000000..10005000 54 rows in 0.018 seconds, 0.000 sec/row Chr3:10100000..10105000 85 rows in 0.036 seconds, 0.000 sec/row Chr1:10200000..10205000 83 rows in 0.079 seconds, 0.001 sec/row Chr5:10300000..10305000 70 rows in 0.068 seconds, 0.001 sec/row Chr3:10400000..10405000 79 rows in 0.033 seconds, 0.000 sec/row Chr5:10500000..10505000 55 rows in 0.046 seconds, 0.001 sec/row Chr6:10600000..10605000 75 rows in 0.044 seconds, 0.001 sec/row Chr5:10700000..10705000 62 rows in 0.043 seconds, 0.001 sec/row Chr1:10800000..10805000 68 rows in 0.106 seconds, 0.002 sec/row Chr3:10900000..10905000 73 rows in 0.068 seconds, 0.001 sec/row Chr5:11000000..11005000 76 rows in 0.050 seconds, 0.001 sec/row Chr6:11100000..11105000 53 rows in 0.040 seconds, 0.001 sec/row Chr2:11200000..11205000 64 rows in 0.054 seconds, 0.001 sec/row Chr1:11300000..11305000 67 rows in 0.015 seconds, 0.000 sec/row Chr2:11400000..11405000 52 rows in 0.078 seconds, 0.001 sec/row Chr3:11500000..11505000 70 rows in 0.039 seconds, 0.001 sec/row Chr6:11600000..11605000 64 rows in 0.060 seconds, 0.001 sec/row Chr3:11700000..11705000 70 rows in 0.061 seconds, 0.001 sec/row Chr1:11800000..11805000 72 rows in 0.048 seconds, 0.001 sec/row Chr4:11900000..11905000 53 rows in 0.089 seconds, 0.002 sec/row Chr6:12000000..12005000 65 rows in 0.046 seconds, 0.001 sec/row Chr4:12100000..12105000 75 rows in 0.061 seconds, 0.001 sec/row Chr2:12200000..12205000 62 rows in 0.037 seconds, 0.001 sec/row Chr2:12300000..12305000 53 rows in 0.035 seconds, 0.001 sec/row Chr4:12400000..12405000 75 rows in 0.083 seconds, 0.001 sec/row Chr3:12500000..12505000 63 rows in 0.076 seconds, 0.001 sec/row Chr1:12600000..12605000 78 rows in 0.091 seconds, 0.001 sec/row Chr1:12700000..12705000 71 rows in 0.048 seconds, 0.001 sec/row Chr6:12800000..12805000 54 rows in 0.076 seconds, 0.001 sec/row Chr3:12900000..12905000 70 rows in 0.038 seconds, 0.001 sec/row Chr6:13000000..13005000 59 rows in 0.130 seconds, 0.002 sec/row Chr2:13100000..13105000 69 rows in 0.079 seconds, 0.001 sec/row Chr1:13200000..13205000 72 rows in 0.069 seconds, 0.001 sec/row Chr5:13300000..13305000 69 rows in 0.109 seconds, 0.002 sec/row Chr6:13400000..13405000 68 rows in 0.028 seconds, 0.000 sec/row Chr4:13500000..13505000 70 rows in 0.078 seconds, 0.001 sec/row Chr5:13600000..13605000 60 rows in 0.088 seconds, 0.001 sec/row Chr6:13700000..13705000 70 rows in 0.048 seconds, 0.001 sec/row Chr6:13800000..13805000 59 rows in 0.064 seconds, 0.001 sec/row Chr4:13900000..13905000 79 rows in 0.119 seconds, 0.002 sec/row Chr4:14000000..14005000 77 rows in 0.059 seconds, 0.001 sec/row Chr6:14100000..14105000 60 rows in 0.036 seconds, 0.001 sec/row Chr4:14200000..14205000 81 rows in 0.036 seconds, 0.000 sec/row Chr5:14300000..14305000 54 rows in 0.046 seconds, 0.001 sec/row Chr5:14400000..14405000 65 rows in 0.020 seconds, 0.000 sec/row Chr5:14500000..14505000 63 rows in 0.036 seconds, 0.001 sec/row Chr5:14600000..14605000 74 rows in 0.026 seconds, 0.000 sec/row Chr5:14700000..14705000 72 rows in 0.064 seconds, 0.001 sec/row Chr6:14800000..14805000 74 rows in 0.067 seconds, 0.001 sec/row Chr5:14900000..14905000 75 rows in 0.055 seconds, 0.001 sec/row Chr4:15000000..15005000 61 rows in 0.039 seconds, 0.001 sec/row Chr1:15100000..15105000 63 rows in 0.061 seconds, 0.001 sec/row Chr4:15200000..15205000 75 rows in 0.030 seconds, 0.000 sec/row Chr2:15300000..15305000 68 rows in 0.045 seconds, 0.001 sec/row Chr1:15400000..15405000 64 rows in 0.038 seconds, 0.001 sec/row Chr5:15500000..15505000 76 rows in 0.077 seconds, 0.001 sec/row Chr6:15600000..15605000 78 rows in 0.077 seconds, 0.001 sec/row Chr1:15700000..15705000 61 rows in 0.076 seconds, 0.001 sec/row Chr6:15800000..15805000 76 rows in 0.039 seconds, 0.001 sec/row Chr3:15900000..15905000 83 rows in 0.060 seconds, 0.001 sec/row Chr1:16000000..16005000 61 rows in 0.047 seconds, 0.001 sec/row Chr3:16100000..16105000 66 rows in 0.069 seconds, 0.001 sec/row Chr4:16200000..16205000 73 rows in 0.054 seconds, 0.001 sec/row Chr3:16300000..16305000 65 rows in 0.063 seconds, 0.001 sec/row Chr4:16400000..16405000 52 rows in 0.057 seconds, 0.001 sec/row Chr3:16500000..16505000 67 rows in 0.013 seconds, 0.000 sec/row Chr4:16600000..16605000 66 rows in 0.029 seconds, 0.000 sec/row Chr6:16700000..16705000 64 rows in 0.036 seconds, 0.001 sec/row Chr5:16800000..16805000 69 rows in 0.057 seconds, 0.001 sec/row Chr2:16900000..16905000 66 rows in 0.037 seconds, 0.001 sec/row Chr1:17000000..17005000 66 rows in 0.051 seconds, 0.001 sec/row Chr1:17100000..17105000 65 rows in 0.005 seconds, 0.000 sec/row Chr3:17200000..17205000 69 rows in 0.080 seconds, 0.001 sec/row Chr6:17300000..17305000 72 rows in 0.091 seconds, 0.001 sec/row Chr6:17400000..17405000 66 rows in 0.039 seconds, 0.001 sec/row Chr3:17500000..17505000 65 rows in 0.020 seconds, 0.000 sec/row Chr2:17600000..17605000 65 rows in 0.069 seconds, 0.001 sec/row Chr1:17700000..17705000 62 rows in 0.086 seconds, 0.001 sec/row Chr3:17800000..17805000 65 rows in 0.059 seconds, 0.001 sec/row Chr2:17900000..17905000 65 rows in 0.054 seconds, 0.001 sec/row Chr6:18000000..18005000 75 rows in 0.065 seconds, 0.001 sec/row Chr1:18100000..18105000 81 rows in 0.029 seconds, 0.000 sec/row Chr3:18200000..18205000 69 rows in 0.039 seconds, 0.001 sec/row Chr1:18300000..18305000 70 rows in 0.054 seconds, 0.001 sec/row Chr2:18400000..18405000 73 rows in 0.080 seconds, 0.001 sec/row Chr6:18500000..18505000 64 rows in 0.042 seconds, 0.001 sec/row Chr2:18600000..18605000 70 rows in 0.024 seconds, 0.000 sec/row Chr2:18700000..18705000 63 rows in 0.026 seconds, 0.000 sec/row Chr5:18800000..18805000 58 rows in 0.108 seconds, 0.002 sec/row Chr5:18900000..18905000 66 rows in 0.066 seconds, 0.001 sec/row Chr3:19000000..19005000 69 rows in 0.033 seconds, 0.000 sec/row Chr6:19100000..19105000 71 rows in 0.065 seconds, 0.001 sec/row Chr2:19200000..19205000 72 rows in 0.065 seconds, 0.001 sec/row Chr4:19300000..19305000 83 rows in 0.084 seconds, 0.001 sec/row Chr5:19400000..19405000 72 rows in 0.045 seconds, 0.001 sec/row Chr5:19500000..19505000 77 rows in 0.057 seconds, 0.001 sec/row Chr6:19600000..19605000 101 rows in 0.065 seconds, 0.001 sec/row Chr4:19700000..19705000 68 rows in 0.017 seconds, 0.000 sec/row Chr4:19800000..19805000 88 rows in 0.018 seconds, 0.000 sec/row Chr5:19900000..19905000 63 rows in 0.042 seconds, 0.001 sec/row Chr3:20000000..20005000 53 rows in 0.074 seconds, 0.001 sec/row Chr3:20100000..20105000 74 rows in 0.048 seconds, 0.001 sec/row Chr1:20200000..20205000 65 rows in 0.044 seconds, 0.001 sec/row Chr2:20300000..20305000 75 rows in 0.016 seconds, 0.000 sec/row Chr6:20400000..20405000 60 rows in 0.128 seconds, 0.002 sec/row Chr5:20500000..20505000 61 rows in 0.050 seconds, 0.001 sec/row Chr4:20600000..20605000 65 rows in 0.031 seconds, 0.000 sec/row Chr3:20700000..20705000 62 rows in 0.015 seconds, 0.000 sec/row Chr4:20800000..20805000 62 rows in 0.039 seconds, 0.001 sec/row Chr1:20900000..20905000 65 rows in 0.022 seconds, 0.000 sec/row Chr1:21000000..21005000 77 rows in 0.056 seconds, 0.001 sec/row Chr4:21100000..21105000 82 rows in 0.078 seconds, 0.001 sec/row Chr5:21200000..21205000 62 rows in 0.006 seconds, 0.000 sec/row Chr6:21300000..21305000 75 rows in 0.045 seconds, 0.001 sec/row Chr2:21400000..21405000 57 rows in 0.019 seconds, 0.000 sec/row Chr5:21500000..21505000 63 rows in 0.026 seconds, 0.000 sec/row Chr4:21600000..21605000 70 rows in 0.021 seconds, 0.000 sec/row Chr3:21700000..21705000 71 rows in 0.030 seconds, 0.000 sec/row Chr4:21800000..21805000 80 rows in 0.037 seconds, 0.000 sec/row Chr4:21900000..21905000 74 rows in 0.044 seconds, 0.001 sec/row Chr4:22000000..22005000 72 rows in 0.049 seconds, 0.001 sec/row Chr2:22100000..22105000 71 rows in 0.014 seconds, 0.000 sec/row Chr6:22200000..22205000 67 rows in 0.030 seconds, 0.000 sec/row Chr5:22300000..22305000 65 rows in 0.083 seconds, 0.001 sec/row Chr1:22400000..22405000 74 rows in 0.021 seconds, 0.000 sec/row Chr1:22500000..22505000 69 rows in 0.006 seconds, 0.000 sec/row Chr6:22600000..22605000 77 rows in 0.069 seconds, 0.001 sec/row Chr3:22700000..22705000 76 rows in 0.209 seconds, 0.003 sec/row Chr6:22800000..22805000 68 rows in 0.032 seconds, 0.000 sec/row Chr2:22900000..22905000 56 rows in 0.065 seconds, 0.001 sec/row Chr2:23000000..23005000 80 rows in 0.017 seconds, 0.000 sec/row Chr2:23100000..23105000 73 rows in 0.051 seconds, 0.001 sec/row Chr1:23200000..23205000 66 rows in 0.025 seconds, 0.000 sec/row Chr6:23300000..23305000 72 rows in 0.062 seconds, 0.001 sec/row Chr3:23400000..23405000 57 rows in 0.053 seconds, 0.001 sec/row Chr6:23500000..23505000 78 rows in 0.062 seconds, 0.001 sec/row Chr5:23600000..23605000 58 rows in 0.057 seconds, 0.001 sec/row Chr2:23700000..23705000 61 rows in 0.040 seconds, 0.001 sec/row Chr6:23800000..23805000 82 rows in 0.055 seconds, 0.001 sec/row Chr2:23900000..23905000 71 rows in 0.101 seconds, 0.001 sec/row Chr6:24000000..24005000 70 rows in 0.011 seconds, 0.000 sec/row Chr3:24100000..24105000 65 rows in 0.094 seconds, 0.001 sec/row Chr2:24200000..24205000 73 rows in 0.115 seconds, 0.002 sec/row Chr2:24300000..24305000 59 rows in 0.024 seconds, 0.000 sec/row Chr2:24400000..24405000 61 rows in 0.052 seconds, 0.001 sec/row Chr2:24500000..24505000 70 rows in 0.085 seconds, 0.001 sec/row Chr6:24600000..24605000 58 rows in 0.105 seconds, 0.002 sec/row Chr1:24700000..24705000 80 rows in 0.087 seconds, 0.001 sec/row Chr4:24800000..24805000 65 rows in 0.095 seconds, 0.001 sec/row Chr6:24900000..24905000 77 rows in 0.111 seconds, 0.001 sec/row --Boundary_(ID_VQjQ5/woyabzdpmsMsrzWw) Content-type: text/plain; charset=us-ascii; name=bin_pg.txt Content-transfer-encoding: 7BIT Content-disposition: attachment; filename=bin_pg.txt Chr2:0..5000 76 rows in 32.371 seconds, 0.426 sec/row Chr1:100000..105000 66 rows in 32.337 seconds, 0.490 sec/row Chr1:200000..205000 80 rows in 32.340 seconds, 0.404 sec/row Chr2:300000..305000 70 rows in 32.282 seconds, 0.461 sec/row Chr1:400000..405000 67 rows in 32.336 seconds, 0.483 sec/row Chr1:500000..505000 55 rows in 36.841 seconds, 0.670 sec/row Chr4:600000..605000 67 rows in 35.498 seconds, 0.530 sec/row Chr5:700000..705000 66 rows in 36.120 seconds, 0.547 sec/row Chr2:800000..805000 77 rows in 37.576 seconds, 0.488 sec/row Chr5:900000..905000 72 rows in 37.261 seconds, 0.518 sec/row Chr5:1000000..1005000 67 rows in 34.752 seconds, 0.519 sec/row Chr2:1100000..1105000 53 rows in 37.367 seconds, 0.705 sec/row Chr1:1200000..1205000 72 rows in 45.172 seconds, 0.627 sec/row Chr5:1300000..1305000 84 rows in 39.484 seconds, 0.470 sec/row Chr5:1400000..1405000 72 rows in 32.915 seconds, 0.457 sec/row Chr5:1500000..1505000 74 rows in 32.742 seconds, 0.442 sec/row Chr3:1600000..1605000 66 rows in 32.937 seconds, 0.499 sec/row Chr2:1700000..1705000 72 rows in 32.711 seconds, 0.454 sec/row Chr5:1800000..1805000 60 rows in 32.521 seconds, 0.542 sec/row Chr2:1900000..1905000 68 rows in 32.580 seconds, 0.479 sec/row Chr3:2000000..2005000 72 rows in 32.674 seconds, 0.454 sec/row Chr5:2100000..2105000 72 rows in 32.472 seconds, 0.451 sec/row Chr6:2200000..2205000 70 rows in 33.062 seconds, 0.472 sec/row Chr2:2300000..2305000 74 rows in 32.680 seconds, 0.442 sec/row Chr4:2400000..2405000 77 rows in 32.844 seconds, 0.427 sec/row Chr5:2500000..2505000 73 rows in 32.299 seconds, 0.442 sec/row Chr6:2600000..2605000 77 rows in 32.373 seconds, 0.420 sec/row Chr2:2700000..2705000 66 rows in 32.245 seconds, 0.489 sec/row Chr3:2800000..2805000 60 rows in 32.608 seconds, 0.543 sec/row Chr5:2900000..2905000 70 rows in 32.305 seconds, 0.462 sec/row Chr2:3000000..3005000 68 rows in 32.285 seconds, 0.475 sec/row Chr4:3100000..3105000 74 rows in 32.563 seconds, 0.440 sec/row Chr5:3200000..3205000 61 rows in 32.323 seconds, 0.530 sec/row Chr5:3300000..3305000 82 rows in 32.280 seconds, 0.394 sec/row Chr1:3400000..3405000 66 rows in 32.790 seconds, 0.497 sec/row Chr2:3500000..3505000 64 rows in 32.218 seconds, 0.503 sec/row Chr6:3600000..3605000 81 rows in 32.349 seconds, 0.399 sec/row Chr5:3700000..3705000 67 rows in 32.279 seconds, 0.482 sec/row Chr6:3800000..3805000 70 rows in 32.346 seconds, 0.462 sec/row Chr5:3900000..3905000 69 rows in 32.263 seconds, 0.468 sec/row Chr3:4000000..4005000 55 rows in 32.550 seconds, 0.592 sec/row Chr1:4100000..4105000 66 rows in 32.481 seconds, 0.492 sec/row Chr2:4200000..4205000 60 rows in 32.259 seconds, 0.538 sec/row Chr2:4300000..4305000 64 rows in 32.207 seconds, 0.503 sec/row Chr5:4400000..4405000 64 rows in 32.294 seconds, 0.505 sec/row Chr6:4500000..4505000 55 rows in 32.298 seconds, 0.587 sec/row Chr6:4600000..4605000 83 rows in 32.317 seconds, 0.389 sec/row Chr4:4700000..4705000 75 rows in 32.688 seconds, 0.436 sec/row Chr2:4800000..4805000 68 rows in 32.229 seconds, 0.474 sec/row Chr3:4900000..4905000 65 rows in 32.631 seconds, 0.502 sec/row Chr3:5000000..5005000 71 rows in 32.274 seconds, 0.455 sec/row Chr3:5100000..5105000 64 rows in 32.227 seconds, 0.504 sec/row Chr2:5200000..5205000 58 rows in 32.219 seconds, 0.556 sec/row Chr1:5300000..5305000 69 rows in 32.884 seconds, 0.477 sec/row Chr3:5400000..5405000 66 rows in 32.256 seconds, 0.489 sec/row Chr2:5500000..5505000 70 rows in 32.164 seconds, 0.459 sec/row Chr6:5600000..5605000 70 rows in 32.293 seconds, 0.461 sec/row Chr2:5700000..5705000 59 rows in 32.158 seconds, 0.545 sec/row Chr1:5800000..5805000 69 rows in 32.366 seconds, 0.469 sec/row Chr1:5900000..5905000 79 rows in 32.321 seconds, 0.409 sec/row Chr6:6000000..6005000 57 rows in 32.282 seconds, 0.566 sec/row Chr2:6100000..6105000 71 rows in 32.164 seconds, 0.453 sec/row Chr4:6200000..6205000 92 rows in 32.667 seconds, 0.355 sec/row Chr2:6300000..6305000 80 rows in 32.145 seconds, 0.402 sec/row Chr3:6400000..6405000 85 rows in 32.448 seconds, 0.382 sec/row Chr4:6500000..6505000 87 rows in 32.307 seconds, 0.371 sec/row Chr4:6600000..6605000 70 rows in 32.274 seconds, 0.461 sec/row Chr4:6700000..6705000 68 rows in 32.233 seconds, 0.474 sec/row Chr6:6800000..6805000 64 rows in 32.280 seconds, 0.504 sec/row Chr2:6900000..6905000 75 rows in 32.170 seconds, 0.429 sec/row Chr3:7000000..7005000 72 rows in 32.531 seconds, 0.452 sec/row Chr4:7100000..7105000 67 rows in 32.278 seconds, 0.482 sec/row Chr4:7200000..7205000 66 rows in 32.236 seconds, 0.488 sec/row Chr5:7300000..7305000 73 rows in 32.602 seconds, 0.447 sec/row Chr5:7400000..7405000 68 rows in 32.209 seconds, 0.474 sec/row Chr1:7500000..7505000 69 rows in 32.559 seconds, 0.472 sec/row Chr1:7600000..7605000 47 rows in 32.227 seconds, 0.686 sec/row Chr4:7700000..7705000 65 rows in 32.234 seconds, 0.496 sec/row Chr5:7800000..7805000 63 rows in 32.191 seconds, 0.511 sec/row Chr3:7900000..7905000 75 rows in 32.713 seconds, 0.436 sec/row Chr2:8000000..8005000 69 rows in 32.139 seconds, 0.466 sec/row Chr3:8100000..8105000 70 rows in 32.143 seconds, 0.459 sec/row Chr4:8200000..8205000 69 rows in 32.222 seconds, 0.467 sec/row Chr1:8300000..8305000 76 rows in 32.141 seconds, 0.423 sec/row Chr6:8400000..8405000 81 rows in 32.770 seconds, 0.405 sec/row Chr1:8500000..8505000 56 rows in 32.137 seconds, 0.574 sec/row Chr5:8600000..8605000 70 rows in 32.197 seconds, 0.460 sec/row Chr3:8700000..8705000 67 rows in 32.138 seconds, 0.480 sec/row Chr4:8800000..8805000 61 rows in 32.203 seconds, 0.528 sec/row Chr3:8900000..8905000 80 rows in 32.130 seconds, 0.402 sec/row Chr1:9000000..9005000 72 rows in 32.160 seconds, 0.447 sec/row Chr1:9100000..9105000 71 rows in 32.129 seconds, 0.453 sec/row Chr1:9200000..9205000 80 rows in 32.160 seconds, 0.402 sec/row Chr1:9300000..9305000 60 rows in 32.119 seconds, 0.535 sec/row Chr1:9400000..9405000 77 rows in 32.155 seconds, 0.418 sec/row Chr3:9500000..9505000 51 rows in 32.555 seconds, 0.638 sec/row Chr6:9600000..9605000 72 rows in 32.474 seconds, 0.451 sec/row Chr4:9700000..9705000 59 rows in 32.158 seconds, 0.545 sec/row Chr3:9800000..9805000 67 rows in 32.134 seconds, 0.480 sec/row Chr5:9900000..9905000 67 rows in 32.483 seconds, 0.485 sec/row Chr1:10000000..10005000 54 rows in 32.116 seconds, 0.595 sec/row Chr3:10100000..10105000 85 rows in 32.125 seconds, 0.378 sec/row Chr1:10200000..10205000 83 rows in 32.115 seconds, 0.387 sec/row Chr5:10300000..10305000 70 rows in 32.126 seconds, 0.459 sec/row Chr3:10400000..10405000 79 rows in 32.105 seconds, 0.406 sec/row Chr5:10500000..10505000 55 rows in 32.133 seconds, 0.584 sec/row Chr6:10600000..10605000 75 rows in 32.143 seconds, 0.429 sec/row Chr5:10700000..10705000 62 rows in 32.110 seconds, 0.518 sec/row Chr1:10800000..10805000 68 rows in 32.107 seconds, 0.472 sec/row Chr3:10900000..10905000 73 rows in 32.102 seconds, 0.440 sec/row Chr5:11000000..11005000 76 rows in 32.134 seconds, 0.423 sec/row Chr6:11100000..11105000 53 rows in 32.117 seconds, 0.606 sec/row Chr2:11200000..11205000 64 rows in 34.146 seconds, 0.534 sec/row Chr1:11300000..11305000 67 rows in 32.081 seconds, 0.479 sec/row Chr2:11400000..11405000 52 rows in 32.393 seconds, 0.623 sec/row Chr3:11500000..11505000 70 rows in 32.093 seconds, 0.458 sec/row Chr6:11600000..11605000 64 rows in 32.149 seconds, 0.502 sec/row Chr3:11700000..11705000 70 rows in 32.077 seconds, 0.458 sec/row Chr1:11800000..11805000 72 rows in 32.096 seconds, 0.446 sec/row Chr4:11900000..11905000 53 rows in 32.728 seconds, 0.618 sec/row Chr6:12000000..12005000 65 rows in 32.138 seconds, 0.494 sec/row Chr4:12100000..12105000 75 rows in 32.115 seconds, 0.428 sec/row Chr2:12200000..12205000 62 rows in 32.416 seconds, 0.523 sec/row Chr2:12300000..12305000 53 rows in 32.022 seconds, 0.604 sec/row Chr4:12400000..12405000 75 rows in 32.157 seconds, 0.429 sec/row Chr3:12500000..12505000 63 rows in 32.058 seconds, 0.509 sec/row Chr1:12600000..12605000 78 rows in 32.080 seconds, 0.411 sec/row Chr1:12700000..12705000 71 rows in 32.068 seconds, 0.452 sec/row Chr6:12800000..12805000 54 rows in 32.117 seconds, 0.595 sec/row Chr3:12900000..12905000 70 rows in 32.058 seconds, 0.458 sec/row Chr6:13000000..13005000 59 rows in 32.116 seconds, 0.544 sec/row Chr2:13100000..13105000 69 rows in 32.003 seconds, 0.464 sec/row Chr1:13200000..13205000 72 rows in 32.070 seconds, 0.445 sec/row Chr5:13300000..13305000 69 rows in 32.552 seconds, 0.472 sec/row Chr6:13400000..13405000 68 rows in 32.098 seconds, 0.472 sec/row Chr4:13500000..13505000 70 rows in 32.399 seconds, 0.463 sec/row Chr5:13600000..13605000 60 rows in 32.354 seconds, 0.539 sec/row Chr6:13700000..13705000 70 rows in 32.075 seconds, 0.458 sec/row Chr6:13800000..13805000 59 rows in 32.101 seconds, 0.544 sec/row Chr4:13900000..13905000 79 rows in 32.235 seconds, 0.408 sec/row Chr4:14000000..14005000 77 rows in 32.102 seconds, 0.417 sec/row Chr6:14100000..14105000 60 rows in 32.065 seconds, 0.534 sec/row Chr4:14200000..14205000 81 rows in 32.104 seconds, 0.396 sec/row Chr5:14300000..14305000 54 rows in 32.293 seconds, 0.598 sec/row Chr5:14400000..14405000 65 rows in 32.060 seconds, 0.493 sec/row Chr5:14500000..14505000 63 rows in 32.030 seconds, 0.508 sec/row Chr5:14600000..14605000 74 rows in 32.042 seconds, 0.433 sec/row Chr5:14700000..14705000 72 rows in 32.012 seconds, 0.445 sec/row Chr6:14800000..14805000 74 rows in 32.075 seconds, 0.433 sec/row Chr5:14900000..14905000 75 rows in 32.005 seconds, 0.427 sec/row Chr4:15000000..15005000 61 rows in 32.065 seconds, 0.526 sec/row Chr1:15100000..15105000 63 rows in 31.981 seconds, 0.508 sec/row Chr4:15200000..15205000 75 rows in 32.084 seconds, 0.428 sec/row Chr2:15300000..15305000 68 rows in 32.269 seconds, 0.475 sec/row Chr1:15400000..15405000 64 rows in 32.011 seconds, 0.500 sec/row Chr5:15500000..15505000 76 rows in 31.995 seconds, 0.421 sec/row Chr6:15600000..15605000 78 rows in 32.052 seconds, 0.411 sec/row Chr1:15700000..15705000 61 rows in 31.983 seconds, 0.524 sec/row Chr6:15800000..15805000 76 rows in 32.907 seconds, 0.433 sec/row Chr3:15900000..15905000 83 rows in 32.342 seconds, 0.390 sec/row Chr1:16000000..16005000 61 rows in 32.002 seconds, 0.525 sec/row Chr3:16100000..16105000 66 rows in 32.032 seconds, 0.485 sec/row Chr4:16200000..16205000 73 rows in 32.601 seconds, 0.447 sec/row Chr3:16300000..16305000 65 rows in 32.147 seconds, 0.495 sec/row Chr4:16400000..16405000 52 rows in 32.150 seconds, 0.618 sec/row Chr3:16500000..16505000 67 rows in 31.969 seconds, 0.477 sec/row Chr4:16600000..16605000 66 rows in 32.035 seconds, 0.485 sec/row Chr6:16700000..16705000 64 rows in 31.994 seconds, 0.500 sec/row Chr5:16800000..16805000 69 rows in 33.532 seconds, 0.486 sec/row Chr2:16900000..16905000 66 rows in 32.330 seconds, 0.490 sec/row Chr1:17000000..17005000 66 rows in 32.222 seconds, 0.488 sec/row Chr1:17100000..17105000 65 rows in 31.975 seconds, 0.492 sec/row Chr3:17200000..17205000 69 rows in 31.960 seconds, 0.463 sec/row Chr6:17300000..17305000 72 rows in 32.578 seconds, 0.452 sec/row Chr6:17400000..17405000 66 rows in 32.021 seconds, 0.485 sec/row Chr3:17500000..17505000 65 rows in 31.935 seconds, 0.491 sec/row Chr2:17600000..17605000 65 rows in 31.913 seconds, 0.491 sec/row Chr1:17700000..17705000 62 rows in 31.940 seconds, 0.515 sec/row Chr3:17800000..17805000 65 rows in 31.958 seconds, 0.492 sec/row Chr2:17900000..17905000 65 rows in 31.880 seconds, 0.490 sec/row Chr6:18000000..18005000 75 rows in 32.009 seconds, 0.427 sec/row Chr1:18100000..18105000 81 rows in 31.935 seconds, 0.394 sec/row Chr3:18200000..18205000 69 rows in 31.950 seconds, 0.463 sec/row Chr1:18300000..18305000 70 rows in 31.914 seconds, 0.456 sec/row Chr2:18400000..18405000 73 rows in 31.890 seconds, 0.437 sec/row Chr6:18500000..18505000 64 rows in 31.956 seconds, 0.499 sec/row Chr2:18600000..18605000 70 rows in 31.897 seconds, 0.456 sec/row Chr2:18700000..18705000 63 rows in 31.864 seconds, 0.506 sec/row Chr5:18800000..18805000 58 rows in 32.159 seconds, 0.554 sec/row Chr5:18900000..18905000 66 rows in 31.959 seconds, 0.484 sec/row Chr3:19000000..19005000 69 rows in 31.932 seconds, 0.463 sec/row Chr6:19100000..19105000 71 rows in 31.945 seconds, 0.450 sec/row Chr2:19200000..19205000 72 rows in 31.887 seconds, 0.443 sec/row Chr4:19300000..19305000 83 rows in 32.317 seconds, 0.389 sec/row Chr5:19400000..19405000 72 rows in 31.945 seconds, 0.444 sec/row Chr5:19500000..19505000 77 rows in 31.897 seconds, 0.414 sec/row Chr6:19600000..19605000 101 rows in 31.943 seconds, 0.316 sec/row Chr4:19700000..19705000 68 rows in 31.935 seconds, 0.470 sec/row Chr4:19800000..19805000 88 rows in 31.971 seconds, 0.363 sec/row Chr5:19900000..19905000 63 rows in 31.894 seconds, 0.506 sec/row Chr3:20000000..20005000 53 rows in 32.282 seconds, 0.609 sec/row Chr3:20100000..20105000 74 rows in 31.892 seconds, 0.431 sec/row Chr1:20200000..20205000 65 rows in 32.635 seconds, 0.502 sec/row Chr2:20300000..20305000 75 rows in 32.251 seconds, 0.430 sec/row Chr6:20400000..20405000 60 rows in 32.406 seconds, 0.540 sec/row Chr5:20500000..20505000 61 rows in 31.888 seconds, 0.523 sec/row Chr4:20600000..20605000 65 rows in 31.910 seconds, 0.491 sec/row Chr3:20700000..20705000 62 rows in 31.880 seconds, 0.514 sec/row Chr4:20800000..20805000 62 rows in 31.923 seconds, 0.515 sec/row Chr1:20900000..20905000 65 rows in 32.272 seconds, 0.496 sec/row Chr1:21000000..21005000 77 rows in 31.871 seconds, 0.414 sec/row Chr4:21100000..21105000 82 rows in 31.906 seconds, 0.389 sec/row Chr5:21200000..21205000 62 rows in 31.926 seconds, 0.515 sec/row Chr6:21300000..21305000 75 rows in 32.250 seconds, 0.430 sec/row Chr2:21400000..21405000 57 rows in 32.104 seconds, 0.563 sec/row Chr5:21500000..21505000 63 rows in 32.077 seconds, 0.509 sec/row Chr4:21600000..21605000 70 rows in 31.956 seconds, 0.457 sec/row Chr3:21700000..21705000 71 rows in 32.112 seconds, 0.452 sec/row Chr4:21800000..21805000 80 rows in 31.890 seconds, 0.399 sec/row Chr4:21900000..21905000 74 rows in 31.877 seconds, 0.431 sec/row Chr4:22000000..22005000 72 rows in 31.891 seconds, 0.443 sec/row Chr2:22100000..22105000 71 rows in 31.971 seconds, 0.450 sec/row Chr6:22200000..22205000 67 rows in 32.288 seconds, 0.482 sec/row Chr5:22300000..22305000 65 rows in 32.003 seconds, 0.492 sec/row Chr1:22400000..22405000 74 rows in 32.324 seconds, 0.437 sec/row Chr1:22500000..22505000 69 rows in 31.894 seconds, 0.462 sec/row Chr6:22600000..22605000 77 rows in 31.924 seconds, 0.415 sec/row Chr3:22700000..22705000 76 rows in 32.303 seconds, 0.425 sec/row Chr6:22800000..22805000 68 rows in 31.883 seconds, 0.469 sec/row Chr2:22900000..22905000 56 rows in 32.029 seconds, 0.572 sec/row Chr2:23000000..23005000 80 rows in 31.826 seconds, 0.398 sec/row Chr2:23100000..23105000 73 rows in 31.756 seconds, 0.435 sec/row Chr1:23200000..23205000 66 rows in 31.927 seconds, 0.484 sec/row Chr6:23300000..23305000 72 rows in 31.840 seconds, 0.442 sec/row Chr3:23400000..23405000 57 rows in 32.012 seconds, 0.562 sec/row Chr6:23500000..23505000 78 rows in 31.838 seconds, 0.408 sec/row Chr5:23600000..23605000 58 rows in 32.020 seconds, 0.552 sec/row Chr2:23700000..23705000 61 rows in 31.766 seconds, 0.521 sec/row Chr6:23800000..23805000 82 rows in 31.833 seconds, 0.388 sec/row Chr2:23900000..23905000 71 rows in 31.738 seconds, 0.447 sec/row Chr6:24000000..24005000 70 rows in 31.837 seconds, 0.455 sec/row Chr3:24100000..24105000 65 rows in 31.785 seconds, 0.489 sec/row Chr2:24200000..24205000 73 rows in 31.746 seconds, 0.435 sec/row Chr2:24300000..24305000 59 rows in 31.728 seconds, 0.538 sec/row Chr2:24400000..24405000 61 rows in 31.741 seconds, 0.520 sec/row Chr2:24500000..24505000 70 rows in 31.732 seconds, 0.453 sec/row Chr6:24600000..24605000 58 rows in 31.833 seconds, 0.549 sec/row Chr1:24700000..24705000 80 rows in 31.758 seconds, 0.397 sec/row Chr4:24800000..24805000 65 rows in 32.302 seconds, 0.497 sec/row Chr6:24900000..24905000 77 rows in 31.802 seconds, 0.413 sec/row --Boundary_(ID_VQjQ5/woyabzdpmsMsrzWw) Content-type: text/plain; charset=us-ascii; name=nobin_mysql.txt Content-transfer-encoding: 7BIT Content-disposition: attachment; filename=nobin_mysql.txt Chr2:0..5000 76 rows in 0.247 seconds, 0.003 sec/row Chr1:100000..105000 66 rows in 2.391 seconds, 0.036 sec/row Chr1:200000..205000 80 rows in 1.538 seconds, 0.019 sec/row Chr2:300000..305000 70 rows in 2.551 seconds, 0.036 sec/row Chr1:400000..405000 67 rows in 0.689 seconds, 0.010 sec/row Chr1:500000..505000 55 rows in 0.393 seconds, 0.007 sec/row Chr4:600000..605000 67 rows in 0.882 seconds, 0.013 sec/row Chr5:700000..705000 66 rows in 0.435 seconds, 0.007 sec/row Chr2:800000..805000 77 rows in 0.407 seconds, 0.005 sec/row Chr5:900000..905000 72 rows in 0.345 seconds, 0.005 sec/row Chr5:1000000..1005000 68 rows in 0.351 seconds, 0.005 sec/row Chr2:1100000..1105000 53 rows in 0.397 seconds, 0.007 sec/row Chr1:1200000..1205000 72 rows in 0.529 seconds, 0.007 sec/row Chr5:1300000..1305000 84 rows in 0.468 seconds, 0.006 sec/row Chr5:1400000..1405000 72 rows in 0.483 seconds, 0.007 sec/row Chr5:1500000..1505000 74 rows in 0.516 seconds, 0.007 sec/row Chr3:1600000..1605000 66 rows in 0.577 seconds, 0.009 sec/row Chr2:1700000..1705000 72 rows in 0.621 seconds, 0.009 sec/row Chr5:1800000..1805000 60 rows in 0.618 seconds, 0.010 sec/row Chr2:1900000..1905000 68 rows in 0.650 seconds, 0.010 sec/row Chr3:2000000..2005000 73 rows in 0.683 seconds, 0.009 sec/row Chr5:2100000..2105000 72 rows in 0.722 seconds, 0.010 sec/row Chr6:2200000..2205000 70 rows in 0.769 seconds, 0.011 sec/row Chr2:2300000..2305000 74 rows in 0.787 seconds, 0.011 sec/row Chr4:2400000..2405000 77 rows in 0.829 seconds, 0.011 sec/row Chr5:2500000..2505000 73 rows in 0.860 seconds, 0.012 sec/row Chr6:2600000..2605000 77 rows in 0.900 seconds, 0.012 sec/row Chr2:2700000..2705000 66 rows in 0.921 seconds, 0.014 sec/row Chr3:2800000..2805000 60 rows in 0.951 seconds, 0.016 sec/row Chr5:2900000..2905000 70 rows in 0.999 seconds, 0.014 sec/row Chr2:3000000..3005000 70 rows in 1.021 seconds, 0.015 sec/row Chr4:3100000..3105000 74 rows in 1.069 seconds, 0.014 sec/row Chr5:3200000..3205000 61 rows in 1.102 seconds, 0.018 sec/row Chr5:3300000..3305000 82 rows in 1.134 seconds, 0.014 sec/row Chr1:3400000..3405000 66 rows in 1.157 seconds, 0.018 sec/row Chr2:3500000..3505000 64 rows in 1.198 seconds, 0.019 sec/row Chr6:3600000..3605000 81 rows in 1.249 seconds, 0.015 sec/row Chr5:3700000..3705000 67 rows in 1.271 seconds, 0.019 sec/row Chr6:3800000..3805000 70 rows in 1.316 seconds, 0.019 sec/row Chr5:3900000..3905000 69 rows in 1.341 seconds, 0.019 sec/row Chr3:4000000..4005000 60 rows in 1.359 seconds, 0.023 sec/row Chr1:4100000..4105000 66 rows in 1.391 seconds, 0.021 sec/row Chr2:4200000..4205000 60 rows in 1.430 seconds, 0.024 sec/row Chr2:4300000..4305000 64 rows in 1.467 seconds, 0.023 sec/row Chr5:4400000..4405000 64 rows in 1.516 seconds, 0.024 sec/row Chr6:4500000..4505000 55 rows in 1.561 seconds, 0.028 sec/row Chr6:4600000..4605000 83 rows in 1.599 seconds, 0.019 sec/row Chr4:4700000..4705000 75 rows in 1.615 seconds, 0.022 sec/row Chr2:4800000..4805000 68 rows in 1.634 seconds, 0.024 sec/row Chr3:4900000..4905000 65 rows in 1.662 seconds, 0.026 sec/row Chr3:5000000..5005000 73 rows in 1.692 seconds, 0.023 sec/row Chr3:5100000..5105000 64 rows in 1.726 seconds, 0.027 sec/row Chr2:5200000..5205000 58 rows in 1.771 seconds, 0.031 sec/row Chr1:5300000..5305000 69 rows in 1.795 seconds, 0.026 sec/row Chr3:5400000..5405000 66 rows in 1.824 seconds, 0.028 sec/row Chr2:5500000..5505000 70 rows in 1.874 seconds, 0.027 sec/row Chr6:5600000..5605000 70 rows in 1.945 seconds, 0.028 sec/row Chr2:5700000..5705000 59 rows in 1.941 seconds, 0.033 sec/row Chr1:5800000..5805000 69 rows in 1.967 seconds, 0.029 sec/row Chr1:5900000..5905000 79 rows in 2.001 seconds, 0.025 sec/row Chr6:6000000..6005000 60 rows in 2.085 seconds, 0.035 sec/row Chr2:6100000..6105000 71 rows in 2.079 seconds, 0.029 sec/row Chr4:6200000..6205000 92 rows in 2.132 seconds, 0.023 sec/row Chr2:6300000..6305000 80 rows in 2.145 seconds, 0.027 sec/row Chr3:6400000..6405000 85 rows in 2.168 seconds, 0.026 sec/row Chr4:6500000..6505000 87 rows in 2.228 seconds, 0.026 sec/row Chr4:6600000..6605000 70 rows in 2.262 seconds, 0.032 sec/row Chr4:6700000..6705000 68 rows in 2.299 seconds, 0.034 sec/row Chr6:6800000..6805000 64 rows in 2.363 seconds, 0.037 sec/row Chr2:6900000..6905000 75 rows in 2.352 seconds, 0.031 sec/row Chr3:7000000..7005000 73 rows in 2.371 seconds, 0.032 sec/row Chr4:7100000..7105000 67 rows in 2.437 seconds, 0.036 sec/row Chr4:7200000..7205000 66 rows in 2.468 seconds, 0.037 sec/row Chr5:7300000..7305000 73 rows in 2.506 seconds, 0.034 sec/row Chr5:7400000..7405000 68 rows in 2.521 seconds, 0.037 sec/row Chr1:7500000..7505000 69 rows in 2.553 seconds, 0.037 sec/row Chr1:7600000..7605000 47 rows in 2.579 seconds, 0.055 sec/row Chr4:7700000..7705000 65 rows in 2.652 seconds, 0.041 sec/row Chr5:7800000..7805000 63 rows in 2.658 seconds, 0.042 sec/row Chr3:7900000..7905000 75 rows in 2.682 seconds, 0.036 sec/row Chr2:8000000..8005000 73 rows in 2.727 seconds, 0.037 sec/row Chr3:8100000..8105000 70 rows in 2.748 seconds, 0.039 sec/row Chr4:8200000..8205000 69 rows in 2.823 seconds, 0.041 sec/row Chr1:8300000..8305000 76 rows in 2.825 seconds, 0.037 sec/row Chr6:8400000..8405000 81 rows in 2.910 seconds, 0.036 sec/row Chr1:8500000..8505000 56 rows in 2.883 seconds, 0.051 sec/row Chr5:8600000..8605000 70 rows in 2.940 seconds, 0.042 sec/row Chr3:8700000..8705000 67 rows in 3.020 seconds, 0.045 sec/row Chr4:8800000..8805000 61 rows in 3.036 seconds, 0.050 sec/row Chr3:8900000..8905000 80 rows in 3.014 seconds, 0.038 sec/row Chr1:9000000..9005000 79 rows in 3.050 seconds, 0.039 sec/row Chr1:9100000..9105000 71 rows in 3.086 seconds, 0.043 sec/row Chr1:9200000..9205000 80 rows in 3.115 seconds, 0.039 sec/row Chr1:9300000..9305000 60 rows in 3.154 seconds, 0.053 sec/row Chr1:9400000..9405000 77 rows in 3.188 seconds, 0.041 sec/row Chr3:9500000..9505000 51 rows in 3.217 seconds, 0.063 sec/row Chr6:9600000..9605000 72 rows in 3.326 seconds, 0.046 sec/row Chr4:9700000..9705000 59 rows in 3.339 seconds, 0.057 sec/row Chr3:9800000..9805000 67 rows in 3.319 seconds, 0.050 sec/row Chr5:9900000..9905000 67 rows in 3.388 seconds, 0.051 sec/row Chr1:10000000..10005000 54 rows in 3.401 seconds, 0.063 sec/row Chr3:10100000..10105000 85 rows in 3.421 seconds, 0.040 sec/row Chr1:10200000..10205000 83 rows in 3.462 seconds, 0.042 sec/row Chr5:10300000..10305000 70 rows in 3.520 seconds, 0.050 sec/row Chr3:10400000..10405000 79 rows in 3.529 seconds, 0.045 sec/row Chr5:10500000..10505000 55 rows in 3.597 seconds, 0.065 sec/row Chr6:10600000..10605000 75 rows in 3.672 seconds, 0.049 sec/row Chr5:10700000..10705000 62 rows in 3.652 seconds, 0.059 sec/row Chr1:10800000..10805000 68 rows in 3.657 seconds, 0.054 sec/row Chr3:10900000..10905000 73 rows in 3.695 seconds, 0.051 sec/row Chr5:11000000..11005000 79 rows in 3.755 seconds, 0.048 sec/row Chr6:11100000..11105000 53 rows in 3.840 seconds, 0.072 sec/row Chr2:11200000..11205000 64 rows in 3.824 seconds, 0.060 sec/row Chr1:11300000..11305000 67 rows in 3.829 seconds, 0.057 sec/row Chr2:11400000..11405000 52 rows in 3.885 seconds, 0.075 sec/row Chr3:11500000..11505000 70 rows in 3.902 seconds, 0.056 sec/row Chr6:11600000..11605000 64 rows in 4.012 seconds, 0.063 sec/row Chr3:11700000..11705000 70 rows in 3.965 seconds, 0.057 sec/row Chr1:11800000..11805000 72 rows in 3.994 seconds, 0.055 sec/row Chr4:11900000..11905000 53 rows in 4.093 seconds, 0.077 sec/row Chr6:12000000..12005000 66 rows in 4.147 seconds, 0.063 sec/row Chr4:12100000..12105000 75 rows in 4.155 seconds, 0.055 sec/row Chr2:12200000..12205000 62 rows in 4.147 seconds, 0.067 sec/row Chr2:12300000..12305000 53 rows in 4.183 seconds, 0.079 sec/row Chr4:12400000..12405000 75 rows in 4.258 seconds, 0.057 sec/row Chr3:12500000..12505000 63 rows in 4.240 seconds, 0.067 sec/row Chr1:12600000..12605000 78 rows in 4.265 seconds, 0.055 sec/row Chr1:12700000..12705000 71 rows in 4.299 seconds, 0.061 sec/row Chr6:12800000..12805000 54 rows in 4.417 seconds, 0.082 sec/row Chr3:12900000..12905000 70 rows in 4.377 seconds, 0.063 sec/row Chr6:13000000..13005000 61 rows in 4.486 seconds, 0.074 sec/row Chr2:13100000..13105000 69 rows in 4.463 seconds, 0.065 sec/row Chr1:13200000..13205000 72 rows in 4.470 seconds, 0.062 sec/row Chr5:13300000..13305000 69 rows in 4.545 seconds, 0.066 sec/row Chr6:13400000..13405000 68 rows in 4.629 seconds, 0.068 sec/row Chr4:13500000..13505000 70 rows in 4.634 seconds, 0.066 sec/row Chr5:13600000..13605000 60 rows in 4.638 seconds, 0.077 sec/row Chr6:13700000..13705000 70 rows in 4.736 seconds, 0.068 sec/row Chr6:13800000..13805000 59 rows in 4.765 seconds, 0.081 sec/row Chr4:13900000..13905000 79 rows in 4.763 seconds, 0.060 sec/row Chr4:14000000..14005000 77 rows in 4.798 seconds, 0.062 sec/row Chr6:14100000..14105000 60 rows in 4.865 seconds, 0.081 sec/row Chr4:14200000..14205000 81 rows in 4.864 seconds, 0.060 sec/row Chr5:14300000..14305000 54 rows in 4.886 seconds, 0.090 sec/row Chr5:14400000..14405000 65 rows in 4.923 seconds, 0.076 sec/row Chr5:14500000..14505000 63 rows in 4.957 seconds, 0.079 sec/row Chr5:14600000..14605000 74 rows in 4.984 seconds, 0.067 sec/row Chr5:14700000..14705000 72 rows in 5.023 seconds, 0.070 sec/row Chr6:14800000..14805000 74 rows in 5.110 seconds, 0.069 sec/row Chr5:14900000..14905000 75 rows in 5.087 seconds, 0.068 sec/row Chr4:15000000..15005000 66 rows in 5.139 seconds, 0.078 sec/row Chr1:15100000..15105000 63 rows in 5.112 seconds, 0.081 sec/row Chr4:15200000..15205000 75 rows in 5.202 seconds, 0.069 sec/row Chr2:15300000..15305000 68 rows in 5.203 seconds, 0.077 sec/row Chr1:15400000..15405000 64 rows in 5.206 seconds, 0.081 sec/row Chr5:15500000..15505000 76 rows in 5.291 seconds, 0.070 sec/row Chr6:15600000..15605000 78 rows in 5.387 seconds, 0.069 sec/row Chr1:15700000..15705000 61 rows in 5.308 seconds, 0.087 sec/row Chr6:15800000..15805000 76 rows in 5.451 seconds, 0.072 sec/row Chr3:15900000..15905000 83 rows in 5.404 seconds, 0.065 sec/row Chr1:16000000..16005000 64 rows in 5.406 seconds, 0.084 sec/row Chr3:16100000..16105000 66 rows in 5.461 seconds, 0.083 sec/row Chr4:16200000..16205000 73 rows in 5.550 seconds, 0.076 sec/row Chr3:16300000..16305000 65 rows in 5.532 seconds, 0.085 sec/row Chr4:16400000..16405000 52 rows in 5.611 seconds, 0.108 sec/row Chr3:16500000..16505000 67 rows in 5.595 seconds, 0.084 sec/row Chr4:16600000..16605000 66 rows in 5.679 seconds, 0.086 sec/row Chr6:16700000..16705000 64 rows in 5.753 seconds, 0.090 sec/row Chr5:16800000..16805000 69 rows in 5.728 seconds, 0.083 sec/row Chr2:16900000..16905000 66 rows in 5.751 seconds, 0.087 sec/row Chr1:17000000..17005000 73 rows in 5.756 seconds, 0.079 sec/row Chr1:17100000..17105000 65 rows in 5.780 seconds, 0.089 sec/row Chr3:17200000..17205000 69 rows in 5.834 seconds, 0.085 sec/row Chr6:17300000..17305000 72 rows in 5.957 seconds, 0.083 sec/row Chr6:17400000..17405000 66 rows in 5.990 seconds, 0.091 sec/row Chr3:17500000..17505000 65 rows in 5.935 seconds, 0.091 sec/row Chr2:17600000..17605000 65 rows in 5.972 seconds, 0.092 sec/row Chr1:17700000..17705000 62 rows in 5.980 seconds, 0.096 sec/row Chr3:17800000..17805000 65 rows in 6.034 seconds, 0.093 sec/row Chr2:17900000..17905000 65 rows in 6.069 seconds, 0.093 sec/row Chr6:18000000..18005000 76 rows in 6.200 seconds, 0.082 sec/row Chr1:18100000..18105000 81 rows in 6.117 seconds, 0.076 sec/row Chr3:18200000..18205000 69 rows in 6.173 seconds, 0.089 sec/row Chr1:18300000..18305000 70 rows in 6.179 seconds, 0.088 sec/row Chr2:18400000..18405000 73 rows in 6.280 seconds, 0.086 sec/row Chr6:18500000..18505000 64 rows in 6.442 seconds, 0.101 sec/row Chr2:18600000..18605000 70 rows in 6.337 seconds, 0.091 sec/row Chr2:18700000..18705000 63 rows in 6.391 seconds, 0.101 sec/row Chr5:18800000..18805000 58 rows in 6.426 seconds, 0.111 sec/row Chr5:18900000..18905000 66 rows in 6.496 seconds, 0.098 sec/row Chr3:19000000..19005000 71 rows in 6.441 seconds, 0.091 sec/row Chr6:19100000..19105000 71 rows in 6.738 seconds, 0.095 sec/row Chr2:19200000..19205000 72 rows in 6.619 seconds, 0.092 sec/row Chr4:19300000..19305000 83 rows in 6.698 seconds, 0.081 sec/row Chr5:19400000..19405000 72 rows in 6.679 seconds, 0.093 sec/row Chr5:19500000..19505000 77 rows in 6.705 seconds, 0.087 sec/row Chr6:19600000..19605000 101 rows in 6.760 seconds, 0.067 sec/row Chr4:19700000..19705000 68 rows in 6.734 seconds, 0.099 sec/row Chr4:19800000..19805000 88 rows in 6.772 seconds, 0.077 sec/row Chr5:19900000..19905000 63 rows in 6.786 seconds, 0.108 sec/row Chr3:20000000..20005000 55 rows in 6.791 seconds, 0.123 sec/row Chr3:20100000..20105000 74 rows in 6.820 seconds, 0.092 sec/row Chr1:20200000..20205000 65 rows in 6.829 seconds, 0.105 sec/row Chr2:20300000..20305000 75 rows in 6.891 seconds, 0.092 sec/row Chr6:20400000..20405000 60 rows in 7.023 seconds, 0.117 sec/row Chr5:20500000..20505000 61 rows in 6.997 seconds, 0.115 sec/row Chr4:20600000..20605000 65 rows in 7.042 seconds, 0.108 sec/row Chr3:20700000..20705000 62 rows in 7.019 seconds, 0.113 sec/row Chr4:20800000..20805000 62 rows in 7.114 seconds, 0.115 sec/row Chr1:20900000..20905000 65 rows in 7.065 seconds, 0.109 sec/row Chr1:21000000..21005000 79 rows in 7.106 seconds, 0.090 sec/row Chr4:21100000..21105000 82 rows in 7.210 seconds, 0.088 sec/row Chr5:21200000..21205000 62 rows in 7.239 seconds, 0.117 sec/row Chr6:21300000..21305000 75 rows in 7.331 seconds, 0.098 sec/row Chr2:21400000..21405000 57 rows in 7.250 seconds, 0.127 sec/row Chr5:21500000..21505000 63 rows in 7.360 seconds, 0.117 sec/row Chr4:21600000..21605000 70 rows in 7.379 seconds, 0.105 sec/row Chr3:21700000..21705000 71 rows in 7.366 seconds, 0.104 sec/row Chr4:21800000..21805000 80 rows in 7.450 seconds, 0.093 sec/row Chr4:21900000..21905000 74 rows in 7.494 seconds, 0.101 sec/row Chr4:22000000..22005000 76 rows in 7.517 seconds, 0.099 sec/row Chr2:22100000..22105000 71 rows in 7.496 seconds, 0.106 sec/row Chr6:22200000..22205000 67 rows in 7.632 seconds, 0.114 sec/row Chr5:22300000..22305000 65 rows in 7.619 seconds, 0.117 sec/row Chr1:22400000..22405000 74 rows in 7.666 seconds, 0.104 sec/row Chr1:22500000..22505000 69 rows in 7.726 seconds, 0.112 sec/row Chr6:22600000..22605000 77 rows in 7.794 seconds, 0.101 sec/row Chr3:22700000..22705000 76 rows in 8.235 seconds, 0.108 sec/row Chr6:22800000..22805000 68 rows in 7.929 seconds, 0.117 sec/row Chr2:22900000..22905000 56 rows in 7.822 seconds, 0.140 sec/row Chr2:23000000..23005000 82 rows in 7.993 seconds, 0.097 sec/row Chr2:23100000..23105000 73 rows in 8.045 seconds, 0.110 sec/row Chr1:23200000..23205000 66 rows in 8.058 seconds, 0.122 sec/row Chr6:23300000..23305000 72 rows in 8.095 seconds, 0.112 sec/row Chr3:23400000..23405000 57 rows in 8.132 seconds, 0.143 sec/row Chr6:23500000..23505000 78 rows in 8.299 seconds, 0.106 sec/row Chr5:23600000..23605000 58 rows in 8.186 seconds, 0.141 sec/row Chr2:23700000..23705000 61 rows in 8.154 seconds, 0.134 sec/row Chr6:23800000..23805000 82 rows in 8.523 seconds, 0.104 sec/row Chr2:23900000..23905000 71 rows in 8.104 seconds, 0.114 sec/row Chr6:24000000..24005000 74 rows in 8.308 seconds, 0.112 sec/row Chr3:24100000..24105000 65 rows in 8.130 seconds, 0.125 sec/row Chr2:24200000..24205000 73 rows in 8.196 seconds, 0.112 sec/row Chr2:24300000..24305000 59 rows in 8.220 seconds, 0.139 sec/row Chr2:24400000..24405000 61 rows in 8.258 seconds, 0.135 sec/row Chr2:24500000..24505000 70 rows in 8.291 seconds, 0.118 sec/row Chr6:24600000..24605000 58 rows in 8.455 seconds, 0.146 sec/row Chr1:24700000..24705000 80 rows in 8.355 seconds, 0.104 sec/row Chr4:24800000..24805000 65 rows in 8.466 seconds, 0.130 sec/row Chr6:24900000..24905000 77 rows in 8.561 seconds, 0.111 sec/row --Boundary_(ID_VQjQ5/woyabzdpmsMsrzWw) Content-type: text/plain; charset=us-ascii; name=nobin_pg.txt Content-transfer-encoding: 7BIT Content-disposition: attachment; filename=nobin_pg.txt Chr2:0..5000 76 rows in 0.021 seconds, 0.000 sec/row Chr1:100000..105000 66 rows in 0.180 seconds, 0.003 sec/row Chr1:200000..205000 80 rows in 0.132 seconds, 0.002 sec/row Chr2:300000..305000 70 rows in 0.515 seconds, 0.007 sec/row Chr1:400000..405000 67 rows in 0.235 seconds, 0.004 sec/row Chr1:500000..505000 55 rows in 0.166 seconds, 0.003 sec/row Chr4:600000..605000 67 rows in 0.833 seconds, 0.012 sec/row Chr5:700000..705000 66 rows in 0.828 seconds, 0.013 sec/row Chr2:800000..805000 77 rows in 0.493 seconds, 0.006 sec/row Chr5:900000..905000 72 rows in 0.236 seconds, 0.003 sec/row Chr5:1000000..1005000 68 rows in 0.139 seconds, 0.002 sec/row Chr2:1100000..1105000 53 rows in 0.389 seconds, 0.007 sec/row Chr1:1200000..1205000 72 rows in 1.482 seconds, 0.021 sec/row Chr5:1300000..1305000 84 rows in 0.363 seconds, 0.004 sec/row Chr5:1400000..1405000 72 rows in 0.150 seconds, 0.002 sec/row Chr5:1500000..1505000 74 rows in 0.126 seconds, 0.002 sec/row Chr3:1600000..1605000 66 rows in 1.890 seconds, 0.029 sec/row Chr2:1700000..1705000 72 rows in 0.621 seconds, 0.009 sec/row Chr5:1800000..1805000 60 rows in 0.394 seconds, 0.007 sec/row Chr2:1900000..1905000 68 rows in 0.272 seconds, 0.004 sec/row Chr3:2000000..2005000 73 rows in 0.659 seconds, 0.009 sec/row Chr5:2100000..2105000 72 rows in 0.407 seconds, 0.006 sec/row Chr6:2200000..2205000 70 rows in 3.974 seconds, 0.057 sec/row Chr2:2300000..2305000 74 rows in 0.508 seconds, 0.007 sec/row Chr4:2400000..2405000 77 rows in 2.313 seconds, 0.030 sec/row Chr5:2500000..2505000 73 rows in 0.365 seconds, 0.005 sec/row Chr6:2600000..2605000 77 rows in 0.510 seconds, 0.007 sec/row Chr2:2700000..2705000 66 rows in 0.494 seconds, 0.007 sec/row Chr3:2800000..2805000 60 rows in 0.731 seconds, 0.012 sec/row Chr5:2900000..2905000 70 rows in 0.426 seconds, 0.006 sec/row Chr2:3000000..3005000 70 rows in 0.404 seconds, 0.006 sec/row Chr4:3100000..3105000 74 rows in 1.056 seconds, 0.014 sec/row Chr5:3200000..3205000 61 rows in 0.360 seconds, 0.006 sec/row Chr5:3300000..3305000 82 rows in 0.156 seconds, 0.002 sec/row Chr1:3400000..3405000 66 rows in 2.154 seconds, 0.033 sec/row Chr2:3500000..3505000 64 rows in 0.549 seconds, 0.009 sec/row Chr6:3600000..3605000 81 rows in 1.100 seconds, 0.014 sec/row Chr5:3700000..3705000 67 rows in 0.550 seconds, 0.008 sec/row Chr6:3800000..3805000 70 rows in 0.199 seconds, 0.003 sec/row Chr5:3900000..3905000 69 rows in 0.287 seconds, 0.004 sec/row Chr3:4000000..4005000 60 rows in 1.183 seconds, 0.020 sec/row Chr1:4100000..4105000 66 rows in 0.666 seconds, 0.010 sec/row Chr2:4200000..4205000 60 rows in 0.741 seconds, 0.012 sec/row Chr2:4300000..4305000 64 rows in 0.194 seconds, 0.003 sec/row Chr5:4400000..4405000 64 rows in 0.622 seconds, 0.010 sec/row Chr6:4500000..4505000 55 rows in 0.660 seconds, 0.012 sec/row Chr6:4600000..4605000 83 rows in 0.288 seconds, 0.003 sec/row Chr4:4700000..4705000 75 rows in 1.358 seconds, 0.018 sec/row Chr2:4800000..4805000 68 rows in 0.534 seconds, 0.008 sec/row Chr3:4900000..4905000 65 rows in 0.950 seconds, 0.015 sec/row Chr3:5000000..5005000 73 rows in 0.206 seconds, 0.003 sec/row Chr3:5100000..5105000 64 rows in 0.234 seconds, 0.004 sec/row Chr2:5200000..5205000 58 rows in 0.474 seconds, 0.008 sec/row Chr1:5300000..5305000 69 rows in 1.265 seconds, 0.018 sec/row Chr3:5400000..5405000 66 rows in 0.329 seconds, 0.005 sec/row Chr2:5500000..5505000 70 rows in 0.408 seconds, 0.006 sec/row Chr6:5600000..5605000 70 rows in 0.914 seconds, 0.013 sec/row Chr2:5700000..5705000 59 rows in 0.277 seconds, 0.005 sec/row Chr1:5800000..5805000 69 rows in 0.537 seconds, 0.008 sec/row Chr1:5900000..5905000 79 rows in 0.217 seconds, 0.003 sec/row Chr6:6000000..6005000 60 rows in 0.543 seconds, 0.009 sec/row Chr2:6100000..6105000 71 rows in 0.416 seconds, 0.006 sec/row Chr4:6200000..6205000 92 rows in 1.615 seconds, 0.018 sec/row Chr2:6300000..6305000 80 rows in 0.286 seconds, 0.004 sec/row Chr3:6400000..6405000 85 rows in 0.907 seconds, 0.011 sec/row Chr4:6500000..6505000 87 rows in 0.354 seconds, 0.004 sec/row Chr4:6600000..6605000 70 rows in 0.173 seconds, 0.002 sec/row Chr4:6700000..6705000 68 rows in 0.247 seconds, 0.004 sec/row Chr6:6800000..6805000 64 rows in 0.845 seconds, 0.013 sec/row Chr2:6900000..6905000 75 rows in 0.569 seconds, 0.008 sec/row Chr3:7000000..7005000 73 rows in 0.714 seconds, 0.010 sec/row Chr4:7100000..7105000 67 rows in 0.664 seconds, 0.010 sec/row Chr4:7200000..7205000 66 rows in 0.288 seconds, 0.004 sec/row Chr5:7300000..7305000 73 rows in 2.244 seconds, 0.031 sec/row Chr5:7400000..7405000 68 rows in 0.336 seconds, 0.005 sec/row Chr1:7500000..7505000 69 rows in 1.168 seconds, 0.017 sec/row Chr1:7600000..7605000 47 rows in 0.171 seconds, 0.004 sec/row Chr4:7700000..7705000 65 rows in 0.704 seconds, 0.011 sec/row Chr5:7800000..7805000 63 rows in 0.581 seconds, 0.009 sec/row Chr3:7900000..7905000 75 rows in 0.821 seconds, 0.011 sec/row Chr2:8000000..8005000 73 rows in 1.023 seconds, 0.014 sec/row Chr3:8100000..8105000 70 rows in 0.293 seconds, 0.004 sec/row Chr4:8200000..8205000 69 rows in 0.557 seconds, 0.008 sec/row Chr1:8300000..8305000 76 rows in 0.586 seconds, 0.008 sec/row Chr6:8400000..8405000 81 rows in 1.258 seconds, 0.016 sec/row Chr1:8500000..8505000 56 rows in 0.240 seconds, 0.004 sec/row Chr5:8600000..8605000 70 rows in 0.903 seconds, 0.013 sec/row Chr3:8700000..8705000 67 rows in 0.603 seconds, 0.009 sec/row Chr4:8800000..8805000 61 rows in 0.606 seconds, 0.010 sec/row Chr3:8900000..8905000 80 rows in 0.357 seconds, 0.004 sec/row Chr1:9000000..9005000 79 rows in 0.533 seconds, 0.007 sec/row Chr1:9100000..9105000 71 rows in 0.255 seconds, 0.004 sec/row Chr1:9200000..9205000 80 rows in 0.278 seconds, 0.003 sec/row Chr1:9300000..9305000 60 rows in 0.239 seconds, 0.004 sec/row Chr1:9400000..9405000 77 rows in 0.266 seconds, 0.003 sec/row Chr3:9500000..9505000 51 rows in 0.700 seconds, 0.014 sec/row Chr6:9600000..9605000 72 rows in 0.973 seconds, 0.014 sec/row Chr4:9700000..9705000 59 rows in 0.783 seconds, 0.013 sec/row Chr3:9800000..9805000 67 rows in 0.460 seconds, 0.007 sec/row Chr5:9900000..9905000 67 rows in 1.011 seconds, 0.015 sec/row Chr1:10000000..10005000 54 rows in 0.584 seconds, 0.011 sec/row Chr3:10100000..10105000 85 rows in 0.425 seconds, 0.005 sec/row Chr1:10200000..10205000 83 rows in 0.361 seconds, 0.004 sec/row Chr5:10300000..10305000 70 rows in 0.526 seconds, 0.008 sec/row Chr3:10400000..10405000 79 rows in 0.379 seconds, 0.005 sec/row Chr5:10500000..10505000 55 rows in 0.279 seconds, 0.005 sec/row Chr6:10600000..10605000 75 rows in 0.949 seconds, 0.013 sec/row Chr5:10700000..10705000 62 rows in 0.312 seconds, 0.005 sec/row Chr1:10800000..10805000 68 rows in 0.518 seconds, 0.008 sec/row Chr3:10900000..10905000 73 rows in 0.544 seconds, 0.007 sec/row Chr5:11000000..11005000 79 rows in 0.400 seconds, 0.005 sec/row Chr6:11100000..11105000 53 rows in 0.524 seconds, 0.010 sec/row Chr2:11200000..11205000 64 rows in 2.255 seconds, 0.035 sec/row Chr1:11300000..11305000 67 rows in 0.475 seconds, 0.007 sec/row Chr2:11400000..11405000 52 rows in 0.343 seconds, 0.007 sec/row Chr3:11500000..11505000 70 rows in 0.642 seconds, 0.009 sec/row Chr6:11600000..11605000 64 rows in 0.541 seconds, 0.008 sec/row Chr3:11700000..11705000 70 rows in 0.374 seconds, 0.005 sec/row Chr1:11800000..11805000 72 rows in 0.531 seconds, 0.007 sec/row Chr4:11900000..11905000 53 rows in 1.523 seconds, 0.029 sec/row Chr6:12000000..12005000 66 rows in 0.419 seconds, 0.006 sec/row Chr4:12100000..12105000 75 rows in 0.435 seconds, 0.006 sec/row Chr2:12200000..12205000 62 rows in 0.764 seconds, 0.012 sec/row Chr2:12300000..12305000 53 rows in 0.410 seconds, 0.008 sec/row Chr4:12400000..12405000 75 rows in 0.486 seconds, 0.006 sec/row Chr3:12500000..12505000 63 rows in 0.809 seconds, 0.013 sec/row Chr1:12600000..12605000 78 rows in 0.833 seconds, 0.011 sec/row Chr1:12700000..12705000 71 rows in 0.298 seconds, 0.004 sec/row Chr6:12800000..12805000 54 rows in 0.550 seconds, 0.010 sec/row Chr3:12900000..12905000 70 rows in 0.470 seconds, 0.007 sec/row Chr6:13000000..13005000 61 rows in 0.348 seconds, 0.006 sec/row Chr2:13100000..13105000 69 rows in 0.896 seconds, 0.013 sec/row Chr1:13200000..13205000 72 rows in 0.668 seconds, 0.009 sec/row Chr5:13300000..13305000 69 rows in 1.628 seconds, 0.024 sec/row Chr6:13400000..13405000 68 rows in 0.608 seconds, 0.009 sec/row Chr4:13500000..13505000 70 rows in 0.889 seconds, 0.013 sec/row Chr5:13600000..13605000 60 rows in 0.542 seconds, 0.009 sec/row Chr6:13700000..13705000 70 rows in 0.493 seconds, 0.007 sec/row Chr6:13800000..13805000 59 rows in 0.281 seconds, 0.005 sec/row Chr4:13900000..13905000 79 rows in 0.430 seconds, 0.005 sec/row Chr4:14000000..14005000 77 rows in 0.267 seconds, 0.003 sec/row Chr6:14100000..14105000 60 rows in 0.416 seconds, 0.007 sec/row Chr4:14200000..14205000 81 rows in 0.362 seconds, 0.004 sec/row Chr5:14300000..14305000 54 rows in 0.666 seconds, 0.012 sec/row Chr5:14400000..14405000 65 rows in 0.379 seconds, 0.006 sec/row Chr5:14500000..14505000 63 rows in 0.324 seconds, 0.005 sec/row Chr5:14600000..14605000 74 rows in 0.361 seconds, 0.005 sec/row Chr5:14700000..14705000 72 rows in 0.361 seconds, 0.005 sec/row Chr6:14800000..14805000 74 rows in 0.588 seconds, 0.008 sec/row Chr5:14900000..14905000 75 rows in 0.397 seconds, 0.005 sec/row Chr4:15000000..15005000 66 rows in 0.711 seconds, 0.011 sec/row Chr1:15100000..15105000 63 rows in 1.221 seconds, 0.019 sec/row Chr4:15200000..15205000 75 rows in 0.407 seconds, 0.005 sec/row Chr2:15300000..15305000 68 rows in 1.662 seconds, 0.024 sec/row Chr1:15400000..15405000 64 rows in 0.498 seconds, 0.008 sec/row Chr5:15500000..15505000 76 rows in 0.619 seconds, 0.008 sec/row Chr6:15600000..15605000 78 rows in 0.716 seconds, 0.009 sec/row Chr1:15700000..15705000 61 rows in 0.493 seconds, 0.008 sec/row Chr6:15800000..15805000 76 rows in 0.362 seconds, 0.005 sec/row Chr3:15900000..15905000 83 rows in 1.819 seconds, 0.022 sec/row Chr1:16000000..16005000 64 rows in 0.460 seconds, 0.007 sec/row Chr3:16100000..16105000 66 rows in 0.374 seconds, 0.006 sec/row Chr4:16200000..16205000 73 rows in 0.825 seconds, 0.011 sec/row Chr3:16300000..16305000 65 rows in 0.393 seconds, 0.006 sec/row Chr4:16400000..16405000 52 rows in 0.374 seconds, 0.007 sec/row Chr3:16500000..16505000 67 rows in 0.384 seconds, 0.006 sec/row Chr4:16600000..16605000 66 rows in 0.432 seconds, 0.007 sec/row Chr6:16700000..16705000 64 rows in 0.812 seconds, 0.013 sec/row Chr5:16800000..16805000 69 rows in 0.916 seconds, 0.013 sec/row Chr2:16900000..16905000 66 rows in 1.095 seconds, 0.017 sec/row Chr1:17000000..17005000 73 rows in 0.901 seconds, 0.012 sec/row Chr1:17100000..17105000 65 rows in 0.401 seconds, 0.006 sec/row Chr3:17200000..17205000 69 rows in 0.642 seconds, 0.009 sec/row Chr6:17300000..17305000 72 rows in 0.581 seconds, 0.008 sec/row Chr6:17400000..17405000 66 rows in 0.378 seconds, 0.006 sec/row Chr3:17500000..17505000 65 rows in 0.513 seconds, 0.008 sec/row Chr2:17600000..17605000 65 rows in 0.611 seconds, 0.009 sec/row Chr1:17700000..17705000 62 rows in 0.607 seconds, 0.010 sec/row Chr3:17800000..17805000 65 rows in 0.437 seconds, 0.007 sec/row Chr2:17900000..17905000 65 rows in 0.542 seconds, 0.008 sec/row Chr6:18000000..18005000 76 rows in 0.642 seconds, 0.008 sec/row Chr1:18100000..18105000 81 rows in 0.458 seconds, 0.006 sec/row Chr3:18200000..18205000 69 rows in 0.555 seconds, 0.008 sec/row Chr1:18300000..18305000 70 rows in 0.429 seconds, 0.006 sec/row Chr2:18400000..18405000 73 rows in 0.654 seconds, 0.009 sec/row Chr6:18500000..18505000 64 rows in 0.601 seconds, 0.009 sec/row Chr2:18600000..18605000 70 rows in 0.453 seconds, 0.006 sec/row Chr2:18700000..18705000 63 rows in 0.405 seconds, 0.006 sec/row Chr5:18800000..18805000 58 rows in 1.097 seconds, 0.019 sec/row Chr5:18900000..18905000 66 rows in 0.367 seconds, 0.006 sec/row Chr3:19000000..19005000 71 rows in 0.648 seconds, 0.009 sec/row Chr6:19100000..19105000 71 rows in 0.579 seconds, 0.008 sec/row Chr2:19200000..19205000 72 rows in 0.636 seconds, 0.009 sec/row Chr4:19300000..19305000 83 rows in 1.391 seconds, 0.017 sec/row Chr5:19400000..19405000 72 rows in 0.502 seconds, 0.007 sec/row Chr5:19500000..19505000 77 rows in 0.431 seconds, 0.006 sec/row Chr6:19600000..19605000 101 rows in 0.582 seconds, 0.006 sec/row Chr4:19700000..19705000 68 rows in 0.528 seconds, 0.008 sec/row Chr4:19800000..19805000 88 rows in 0.433 seconds, 0.005 sec/row Chr5:19900000..19905000 63 rows in 0.520 seconds, 0.008 sec/row Chr3:20000000..20005000 55 rows in 0.689 seconds, 0.013 sec/row Chr3:20100000..20105000 74 rows in 0.405 seconds, 0.005 sec/row Chr1:20200000..20205000 65 rows in 1.274 seconds, 0.020 sec/row Chr2:20300000..20305000 75 rows in 0.863 seconds, 0.012 sec/row Chr6:20400000..20405000 60 rows in 0.771 seconds, 0.013 sec/row Chr5:20500000..20505000 61 rows in 0.636 seconds, 0.010 sec/row Chr4:20600000..20605000 65 rows in 0.633 seconds, 0.010 sec/row Chr3:20700000..20705000 62 rows in 0.711 seconds, 0.011 sec/row Chr4:20800000..20805000 62 rows in 0.436 seconds, 0.007 sec/row Chr1:20900000..20905000 65 rows in 0.703 seconds, 0.011 sec/row Chr1:21000000..21005000 79 rows in 0.432 seconds, 0.005 sec/row Chr4:21100000..21105000 82 rows in 0.528 seconds, 0.006 sec/row Chr5:21200000..21205000 62 rows in 0.640 seconds, 0.010 sec/row Chr6:21300000..21305000 75 rows in 0.656 seconds, 0.009 sec/row Chr2:21400000..21405000 57 rows in 0.966 seconds, 0.017 sec/row Chr5:21500000..21505000 63 rows in 0.641 seconds, 0.010 sec/row Chr4:21600000..21605000 70 rows in 0.634 seconds, 0.009 sec/row Chr3:21700000..21705000 71 rows in 0.769 seconds, 0.011 sec/row Chr4:21800000..21805000 80 rows in 0.500 seconds, 0.006 sec/row Chr4:21900000..21905000 74 rows in 0.449 seconds, 0.006 sec/row Chr4:22000000..22005000 76 rows in 0.481 seconds, 0.006 sec/row Chr2:22100000..22105000 71 rows in 0.705 seconds, 0.010 sec/row Chr6:22200000..22205000 67 rows in 0.644 seconds, 0.010 sec/row Chr5:22300000..22305000 65 rows in 0.838 seconds, 0.013 sec/row Chr1:22400000..22405000 74 rows in 0.958 seconds, 0.013 sec/row Chr1:22500000..22505000 69 rows in 0.507 seconds, 0.007 sec/row Chr6:22600000..22605000 77 rows in 0.612 seconds, 0.008 sec/row Chr3:22700000..22705000 76 rows in 0.738 seconds, 0.010 sec/row Chr6:22800000..22805000 68 rows in 0.531 seconds, 0.008 sec/row Chr2:22900000..22905000 56 rows in 0.756 seconds, 0.014 sec/row Chr2:23000000..23005000 82 rows in 0.458 seconds, 0.006 sec/row Chr2:23100000..23105000 73 rows in 0.504 seconds, 0.007 sec/row Chr1:23200000..23205000 66 rows in 0.640 seconds, 0.010 sec/row Chr6:23300000..23305000 72 rows in 0.685 seconds, 0.010 sec/row Chr3:23400000..23405000 57 rows in 0.780 seconds, 0.014 sec/row Chr6:23500000..23505000 78 rows in 0.530 seconds, 0.007 sec/row Chr5:23600000..23605000 58 rows in 0.979 seconds, 0.017 sec/row Chr2:23700000..23705000 61 rows in 0.743 seconds, 0.012 sec/row Chr6:23800000..23805000 82 rows in 0.712 seconds, 0.009 sec/row Chr2:23900000..23905000 71 rows in 0.524 seconds, 0.007 sec/row Chr6:24000000..24005000 74 rows in 0.530 seconds, 0.007 sec/row Chr3:24100000..24105000 65 rows in 0.687 seconds, 0.011 sec/row Chr2:24200000..24205000 73 rows in 0.610 seconds, 0.008 sec/row Chr2:24300000..24305000 59 rows in 0.511 seconds, 0.009 sec/row Chr2:24400000..24405000 61 rows in 0.500 seconds, 0.008 sec/row Chr2:24500000..24505000 70 rows in 0.501 seconds, 0.007 sec/row Chr6:24600000..24605000 58 rows in 0.669 seconds, 0.012 sec/row Chr1:24700000..24705000 80 rows in 1.057 seconds, 0.013 sec/row Chr4:24800000..24805000 65 rows in 1.541 seconds, 0.024 sec/row Chr6:24900000..24905000 77 rows in 0.618 seconds, 0.008 sec/row --Boundary_(ID_VQjQ5/woyabzdpmsMsrzWw) Content-type: text/plain; charset=us-ascii; name=summary.txt Content-transfer-encoding: 7BIT Content-disposition: attachment; filename=summary.txt Rows/second Method 1st 10% Middle 10% Last 10% Mysql 92.6 14.4 8.4 Mysql bin 454.5 1041.7 1087.0 Postgres 100.4 122.0 98.8 Postgres bin 2.0 2.1 2.1 --Boundary_(ID_VQjQ5/woyabzdpmsMsrzWw)-- ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Gmod-schema mailing list Gmod-schema@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gmod-schema