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

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

Bruce Dunwiddie

Bruce:

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

Thanks, though.

Show quoteHide quote

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


Show quoteHide quote

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

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

VB 6 developers and .Net
Read legacy vb5 files with variant declare in vb.net
How to assign value to a dropdown box items?
How to prevent Pasting into textbox?
ADOX add bool field
efficient routine to parse a text string
How do I replace unwanted characters from a string using Reg Exp?
Memory problem with vb.net + webServices + DLL
clicking on a DataGridView's DataSource property throws exception in designer
keydown event not working problem