Performance issue encountered in ASPSmartUpload

Hi,

I have a small piece of code that uploads a file from the client to the server using ASPSmartUpload. In IE 6.0 there is no problem, however, it seems that when the same file is uploaded using IE 5.5, the upload takes longer. Does anyone have an idea on how to resolve this issue?

Thanks!

Raymond

It may be a database issue, if so, then pretty much there's not much you can do about that.

If it's not a database issue, give me an estimate on the time it takes using IE5.5 vs IE6!

Hi,

Thanks for the quick response. Actually, I tested with several files of different sizes:

small text file (a few hundred bytes or an empty file)
result - sometimes an error page is displayed pointing to the line mySmartUpload.Upload

displayed below is the error:
Error Type:
aspSmartUpload (0x800A0009)
Subscript out of range
/TOPIXCS/common/FileUpload.inc, line 219


Browser Type:
Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)

Page:
POST 622 bytes to /TOPIXCS/common/FileUpload_PerformUpload.asp

POST Data:
error '80020009'
Exception occurred.

/iisHelp/common/500-100.asp, line 223


medium data/txt file
result - file was uploaded but the progress bar stops practically at the center and after a few minutes (estimated around 5 minutes or more than that) it redirects back to the input page

large data/text file (10 mb)
result - file was not uploaded and a script timeout error was displayed in my page

the error is displayed below:

Error Type:
Active Server Pages, ASP 0113 (0x80004005)
The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.
/TOPIXCS/common/FileUpload_PerformUpload.asp


Browser Type:
Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)

Page:
POST 10760814 bytes to /TOPIXCS/common/FileUpload_PerformUpload.asp

POST Data:
error '80020009'
Exception occurred.

/iisHelp/common/500-100.asp, line 223

I tested this in IE 6 and while the 10mb file was uploaded slower, no problem was encountered.

Maybe it would be easier if I post the pseudocode

Input page:

<!--#include file="../Common/FileUpload.inc"-->

<FORM name="frmUpload" method="POST" action="FileUpload_PerformUpload.asp" ENCTYPE="multipart/form-data" onSubmit="return uploadClick()">

<td>
<input name="btnBrowse" type="file" style="WIDTH: 328px" size="30" maxlength="200" value="">
</td>

<td>
<input name ="btnUploadFile" type="submit" value="Upload" class="submit">
</td>

</FORM>

FileUpload_PerformUpload.asp

<!--#include file="FileUpload.inc"-->

iReturn = uploadReportFile()

redirect to input page

FileUpload.inc

function uploadReportFile()

set fso = Server.CreateObject("Scripting.FileSystemObject")
Set mySmartUpload = Server.CreateObject("aspSmartUpload.SmartUpload")
mySmartUpload.Upload

'connect to db to get the location of the destination directory

'do some validation

iUploadCount = mySmartUpload.Save(strDirectory)

from the looks of it, what's the maximum file size that the script can handle? also, what's the minimum size that the script can handle?

also, are you using a database, if so, which one are you using? MSSQL or MS Access?

Actually I'm not really sure where to get the value of the minimum and maximum file size since the files are all uploaded properly when using IE 6. I'm using Oracle database and its just for retrieving of the upload destination path. I'm sure there is no problem with the oracle connectivity since in the case of a medium sized file, the file was uploaded quickly. This implies that it was able to retrieve the destination path of the uploaded file correctly. after that its supposed to redirect to the input page but the progress bar in the status window stays at about 50% for a long time before it completes. I'm beginning to wonder if this is a bug in IE 5.5 and I'm wondering if it would work once I get and install service pack 1

in databases, they all have a limit by default. most times you'll have to change those default setting manually. Oracle, I've never dealt with that db, so I don't know what or how to change it's settings.

what about the upload script, does it have file size limits and such?

Hi,

Thanks for all the effort. I found out whats wrong. In my asp file which calls the upload, there is a line that calls Response.redirect <target url>. I found out that doing this in IE 5.5 after calling the upload function causes a long delay. I resolved it by doing this:

<%
dim iReturn
dim strRequest

iReturn = uploadReportFile()
'do some manipulation to form the target url and assign it to strRequest
%>

<script language="javascript">
parent.location.href = '<%=strRequest%>';
</script>

In IE 6, this works, but in IE 5.5 the target page is not loaded. I also tried to call the javascript in the onload event of the body but it still does not work. Can you suggest an alternative?

thanks!

Raymond