>A friend is asking about quickly inserting data into Oracle. Processing more than 10,000 records in a loop, with INSERT INTO (in a SqlExec()), takes several minutes, he says.
>
>There should be a faster way, but since I have no experience with C/S...
>
>TIA,
>
>Hilmar.
Try to google Oracle BULK Insert. For instance,
http://www.dba-oracle.com/oracle_tips_rittman_bulk%20binds_FORALL.htm
If it's not broken, fix it until it is.
My Blog