- 论坛徽章:
- 0
|
从informix提取数据到本地文件中.
行数是2900行,保存为文件后的大小大概是300K,需要耗时8秒,百M带宽.
效率太底了,有什么另外的方法吗?
- #!/usr/bin/perl -w
- use DBI;
- use DBD::Informix;
- my $database='db';
- my $user='***';
- my $pass='***';
- my $time_before=time;
- my $dbh = DBI->connect("dbi:Informix:$database", $user, $pass,{AutoCommit => 0, PrintError => 1});
- my $sth=$dbh->prepare_cached(qq{select * from vender});
- $sth->execute;
- my $total_row=0;
- open TXT_DATA,">","testdata\.txt";
- my $rows = $sth -> fetchall_arrayref();
- foreach my $row(@$rows){
- print TXT_DATA "$row\n";
- $total_row++;
- }
- close TXT_DATA;
- $dbh->disconnect;
- my $time_after=time;
- my $lost_time=$time_after-$time_before;
- print "lost time : $lost_time\n";
- print "total row: $total_row\n";
复制代码 |
|