Suntower
Posts: 225
|
| Posted: 03/25/2005, 9:06 AM |
|
I was wondering how the -amount- of ASP on a page affects performance.
We expect a max of 50 simultaneous users.
I am converting an app into ASP. The current app has about 20 reports that are all quite similar.
Since the reports -are- all very similar, I was thinking of putting all the code for the reports into one ASP page.
1. Have a blank page with one {label}.
2. Have separate subroutines for each report. Each sub would basically be a SQL statement
3. Each sub would create the entire report into that one label with a LOOP to build the entire html for the report.
I guesstimate that the each report would take 15-20 lines, which means that I would have 20+ subroutines and a total of 400+ lines of code.
Is this considered excessive in terms of server performance? Or is this a stupid question and there are ASP sites with BILLIONS of lines of code on a page and no troubles?
TIA,
---JC
_________________
---On a campaign for more examples and better docs! |
 |
 |
peterr
Posts: 5971
|
| Posted: 03/25/2005, 10:21 AM |
|
We did some testing of this in the past and the amount of ASP code didn't have any significant importance. I think that loading all the common files which have several thousand lines of code was faster than executing a simple database query.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Oper
Posts: 1195
|
| Posted: 03/26/2005, 10:24 AM |
|
its all depend about server.
but as small note we have huge application to mage Call Center( fully Done with CCS + some oterh stuff)
And we sometime has around 90 Users and only get a noticable slow when so many report at the sametime generating PDF report
Only 512mb no SCI drive
we even using Access, withotu a trouble.
we tested with MSSQL and MySQL and the different in speed isnt noticable.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
|
