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

[vvenk]

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

[shriop]

I only know it by name, not anything about how to use it, but check out
http://www.orafaq.com/faqloadr.htm .

Bruce Dunwiddie

[vvenk]

Bruce:

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

Thanks, though.

"shriop" wrote:

I only know it by name, not anything about how to use it, but check out
http://www.orafaq.com/faqloadr.htm .

Bruce Dunwiddie

[Cor Ligthert [MVP]]

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
"vvenk" <vv***@discussions.microsoft.comschreef in bericht
news:73**********************************@microsof t.com...

Bruce:

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

Thanks, though.

"shriop" wrote:

>I only know it by name, not anything about how to use it, but check out
http://www.orafaq.com/faqloadr.htm .

Bruce Dunwiddie

[Paul Clement]

On Sat, 7 Oct 2006 18:14:01 -0700, vvenk <vv***@discussions.microsoft.comwrote:

¤ 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)