hello,i'm now intending to insert some data into mysql using perl
dbi,i first write the code under ubuntu OS and it run perfect(use
aboat 1 second),but when i do the samethings under windows OS,it's
becoming very slow(use aboat 1.5 minute), i wonder what cause this
difference?is there anyway to solve it?

here is my code:
use strict;
use DBI;
my @filename=glob"*.gff";
my ($year,$month,$day)=(localtime)[5,4,3];
    my $TableName="test";
    my $dbh=DBI->connect("dbi:mysql:annotation","root","123456")||die
"$DBI::errstr";
    $dbh->do("DROP TABLE IF EXISTS $TableName");
    my $CreateTable=qq{
    CREATE TABLE $TableName(
`SampleName` char(32) NOT NULL default '',
`PeakID` varchar(16) NOT NULL default '',
`PeakChromosome` varchar(16) NOT NULL default '',
`PeakStart` int(16),
`PeakEnd` int(16),
`PeakLength` int(16),
`PeakScore` float(5,2)
    )};
    $dbh->do($CreateTable);
    my $ImportData=$dbh->prepare("INSERT INTO $TableName
(SampleName,PeakID,PeakChromosome,PeakStart,PeakEnd,PeakLength,PeakScore)
VALUES (?,?,?,?,?,?,?)");
    my $PeakID=0;
    foreach my $filename(@filename){
    print "importing $filename\n";
    $filename=~/(.*)(_635_ratio_peaks.gff|_532_ratio_peaks.gff)/;
    open(IN,"<$filename");
         while(<IN>){
                $PeakID++;
              chomp;
              my @temp=split(/\t/);
              $ImportData->execute($1,$PeakID,$temp[0],$temp[3],$temp
[4],$temp[4]-$temp[3],$temp[5]);
          }
       }

Reply via email to