WE need the large download option. currently we use another product just for the download.

------------
Frank Kwong at 7/11/01 10:51:37 PM

if there is a high demand of large download, I'll implement that in today's version.

FK

------------
Will Schneider at 7/11/01 1:23:16 PM

Thanks for the quick response. I look forward to talking to you. Also for other users out there we made a few changes that improved the download performance by somewhere between 10-25%

Make the paging file on your web server static and not scalable by windows and make the inetinfo process the highest priority.
WCS


------------
Frank Kwong at 7/10/01 9:03:59 PM

1. The download alien HTML code proble should be fixed. Contact your agent for the latest version. If still there, then let me know right away.

2. Large download is a problem. This problem has beeen addressed and I am going to setup a demo to let user try it. HOwever, this solution is not port to the existing versions yet at this time and it is on the 2002 version only. What I did is write the download file to a local file and let user download the file like any other files w/o going thru ASP-db. Send me an email and I'll point you to the demo when it is ready.

FK


------------
Will Schneider at 7/10/01 3:06:49 PM

Hello all,

I am running SQL 7.0 SP3 on NT4.0
IIS 5.0 on WIN 2000 Server SP2 PIII 800MHz 512 MB RAM
ASPDB Version - EP- 6.ASPDB2001-04.13-SP3-ADO21-MTS-Std

First a bug that I can't seem to find the answer to. When I have any download from any recordset (including one from the pubs DB) I get some HTML in the last row of my spreadsheet.

The other problem is download performance. I read two posts concerning this one was from 4/30/01 and his problem is the same as mine. I collected some data about the download speed and have found the following:

The speed can be determined by the number of fieldscells (rows X columns) and relates to this linear function
y = 1434.6x -66.545 where y = fields and x = time (R2 of 0.9758)

What this means for me is that to download the excel limit of 2^16 rows and only 80 columns wide it will take 60 mins to compile the download. This is just the time required to bring the dialog box to the browser asking where to place the file.

My users will be downloading very large recordsets that will approach the excel limit at times. If you apply the equation above, for a two minute wait you can get the following:
Columns Records
-------- --------
5 34417
10 17209
15 11472
20 8604
25 6883
30 5736
35 4917

I need to be able to do about 20 columns and 34000 records in less than a minute if possible. If I run the query in query analyzer the longest one returns in under 30 seconds. If I run an export from Enterprise Manager to and excel or csv file it returns in 30 seconds.

There appears to be a lot of overhead in the dll. When using performance monitor we have been able to track the bottleneck down to the ASPDb dll. It runs the processor at about 70-100% utilization for the duration of the request. This is with one user requesting the file on the local network and no other traffic to the server. I am very hesitant to release this to clients and have several of them hit it and bring the server to its knees.

I have set the response.buffer = true and the dbCount SQL statement. Is there anything else you can suggest. I have stripped the code down to the bare essentials in hopes of reducing the overhead and it did not seem to make a difference.

Any help you can provide would be greatly appreciated.

Will Schneider