插入到mysql数据库时,可以用insert t(a,b,c,d) values(x,x,x,x), (x,x,x,x),...形式的批量语句提高速度。字符串可以用 DBI 的 quote函数处理一下,处理转义字符。sub do_it {?? my $str_sql_from_oracle =?????? "select /*+ parallel(t,4) */ a,b,c,d from tab t";?? my $ora_conn = &get;_oracle_connection("ora", "user", "password");?? my $mysql_conn = &get;_mysql_connection("ip", port, "user", "password");?? #get result set from oracle?? my $rs = &get;_result_set($ora_conn, $str_sql_from_oracle);?? #use batch fetch to get 100 recrods per time.?? while ( my $rows = $rs->fetchall_arrayref(undef, 100)) {? ?? ? #construct the batch insert statement?????? my
...
继续阅读
(19)