What is the optimal way to upload 10,000 records to Oracle DB?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello:

I am writing a ASP application that will take a local CSV file, parse the
data and upload them to a Oracle DB.

I am parsing them and processing one row at a time. Given that there could
be 10,000 rows in the CSV file, I am concerned that it may meet the
functional but not performance requirements.

Can somebody suggest a better way to do accomplish this task?

Venki
 
Bruce:

The SQL Loader is a DOS executable and cannot be integrated with a web app.

Thanks, though.
 
vvenk,

Why not the Process start should run in a webapplication (as long as it is
on the Server and has sufficient rights as well in my opinion).

\\\Notepad
Dim p As New Process
Dim pi As New ProcessStartInfo
pi.arguments = "c:\windows\win.ini"
pi.FileName = "notepad.exe"
p.startinfo = pi
p.Start()
\\\

I hope this helps,
(I am not sure of that)

Cor
 
¤ Hello:
¤
¤ I am writing a ASP application that will take a local CSV file, parse the
¤ data and upload them to a Oracle DB.
¤
¤ I am parsing them and processing one row at a time. Given that there could
¤ be 10,000 rows in the CSV file, I am concerned that it may meet the
¤ functional but not performance requirements.
¤
¤ Can somebody suggest a better way to do accomplish this task?

See if the following helps:

http://www.ddbcinc.com/askDDBC/topic.asp?TOPIC_ID=116


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Back
Top