> my $start_num = $dbh->selectrow_array( "select my_id_seq.nextval from > dual"); > my @seq = ( $start_num..100,000 ); # some end number > > $sth->prepare ( "insert into foo (my_id, data) values (?,?)" ); > $sth->bind_param( 1, shift(@seq) ); > $sth->bind_param( 2, "bar"); > $sth->execute(); >
the 'select from dual' causes a lot of unnecessary overhead. The original method is most performant. Jared
