Hi,

I would like to know, is ASP read excel file take lots of system resource?


I'm doing something like this, read the excel file and insert record from Excel to mssql. If couple of people do this operation, the website is very slow and the CPU usage is 100%
The system is P3 Xeon 700mhz, 4G Ram

Also if i have a excel file which contain around 1000 rows, it always stop at around row 200 (it took around 15 or so minutes), I guess it is dued to the script timeout.


objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & XLFile &";Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""
objConn.Open
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.ActiveConnection = objConn
objRS.CursorType = 3
objRS.LockType = 2
objRS.Source = "Select * from [Sheet1$]"
objRS.Open