| Author |
 Topic  |
|
aecio
Junior Member
Brazil
120 Posts |
 Posted - 01 February 2002 : 18:13:33
|
I am using version 40b03
I have a question that might seem stupid but that has been bothering me for some time now.
I am sure every programmer here is aware how ASP works. From what I understand, and PLEASE, correct me if I'm wrong, the interpreter (ASP.DLL) reads the file and parses what's ASP and what's HTML and processes the ASP, puts the result together with the HTML and sends it to the browser. So each time you open a <% and put ASP, the interpreter is called to interpret it. Then when you close a %>, it stops the DLL and IIS parses the HTML, sending it to the browser.
So, if we open ASP tags all the time, this slows down the code or demands more from the processor.
Hence my question. Was this ever considered? I see too much mixing of HTML and ASP in the forum pages and I was wondering if we couldn't make it faster by using more Response.Write's and less HTML outside of ASP tags? That is to say, make the pages more ASP and less HTML.
Cheers!  < |
|
|
aecio
Junior Member
Brazil
120 Posts |
Posted - 01 February 2002 : 18:18:33
|
Oh, since I am talking about speed, I was wondering if the pure English version, without the internationalization stuff, is faster than the internationalized version, due to less code and less stuff... I would think it is, but does anyone have a more afirmative answer?
Cheers! < |
 |
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 01 February 2002 : 20:03:39
|
It depends on the ASP version. In ASP 2.0 its fastest to avoide the <% %> tags as much as possible. In ASP 3.0 its actually faster to use the <% %> more and the response.writes less. However, the speed gained in ASP 3.0 is insignificant to the speed lost in the ins and outs with ASP version 2.0.
You should find in Snitz version 3.4 many of the files have been converted to mostly responce.write
Nathan Bales - Romans 15:13
---------------------------------
Snitz Exchange | Mod Resource< |
|
|
|
Deleted
deleted
4116 Posts |
Posted - 02 February 2002 : 01:29:32
|
V40B03 is the same as v3.3.03 in these respects. v40b04 will be the same as v3.4. But as said, all html code is converted to response.write's (thanks to Richard).
I don't know the speed difference between v4x and v3x caused by language variables and related includes (1, 2 or more 200k files included and executed on every hit). I tried local and remote testbeds executing 10.000 strings, with or without includes but could not compare them as sending and displaying HTML overrules.
If someone proposes/runs a test method (to measure server load) it will be very much helpful.
We also have an alternate: Dividing the language file into three files (admin, includes + common, normal) to reduce the size/overhead. Didn't decided yet as I don't know anything numerically.
Other ideas, suggestions are welcome.
Think Pink
Test Site not ready yet | Post v40b03 Patches< |
|
|
|
aecio
Junior Member
Brazil
120 Posts |
Posted - 02 February 2002 : 14:18:23
|
What I think I will do is setup a parallel test forum to the one I'm running now with no internationalization, just the plain English forum. I will include timing benchmark scripts in the inc_top and inc_footer to record the load times of the pages and report to you in this thread what I find.
Maybe there will be a difference.
My main concern with all this is that at peak hours, my CPU stays at 70-100% and the DLLHOST is the main user of CPU power (hence, ASP.DLL).
Cheers! < |
|
|
|
stratacafe
Starting Member
Canada
44 Posts |
Posted - 15 February 2002 : 10:44:46
|
This issue is of primary concern to me as well.
I run a site at http://www.stratacafe.com and use Snitz forums.
My sysadmin is reporting that the CPU utilization is spiking regularly. The speed of the site is a big concern for me, and if this is one of the issues slowing down the entire site, I'll have to think about moving to another product.
That's probably not a big concern for you guys, as the product is free. But it would cause me a very nasty headache I would like to avoid. (eg. Attempting to move all of my users and posts to another forum does not appeal to me.)
At this point, I'm debating moving the entire site to MySQL at least, possibly PHP as well. If I'm going to make a change, I might as well make a big one, right?
Is 3.4 faster? Less CPU load? Is Snitz not causing these problems and I should look at the rest of the site?
I have to get back to my sysadmin shortly, be nice to be able to tell him something.
< |
|
|
|
Deleted
deleted
4116 Posts |
|
|
stratacafe
Starting Member
Canada
44 Posts |
Posted - 26 February 2002 : 17:24:13
|
OK, I'm at the "do or die" point now. The forums are eating up every available system resource I have. Once it gets to around 190 MB of physical RAM, it crashes the server.
The culprit is topic.asp
That's about as far as I can narrow it down. I guess it could be an include as well.
Any ideas? I've tracked down every bug I could on this forum related to topic.asp and/or generate dllhost.exe errors.
My site has been up and down for upwards of a week. My host is starting to talk CGI-forums, and at this point I'm about ready to toss in the hat as well.
Can anyone think of an easy way to move 1000 members and 10000 posts to another forum?
< |
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 26 February 2002 : 18:40:57
|
You would need to write a database conversion script.
Are your database connections and record sources gettting closed correctly?
Nathan Bales - Romans 15:13
---------------------------------
Snitz Exchange | Mod Resource< |
|
|
|
Deleted
deleted
4116 Posts |
Posted - 26 February 2002 : 19:49:45
|
quote:
OK, I'm at the "do or die" point now. The forums are eating up every available system resource I have. Once it gets to around 190 MB of physical RAM, it crashes the server.
The culprit is topic.asp
That's about as far as I can narrow it down. I guess it could be an include as well.
Any ideas? I've tracked down every bug I could on this forum related to topic.asp and/or generate dllhost.exe errors.
My site has been up and down for upwards of a week. My host is starting to talk CGI-forums, and at this point I'm about ready to toss in the hat as well.
Can anyone think of an easy way to move 1000 members and 10000 posts to another forum?
Do you want me to help? If yes, please answer these:
* Your database (brand, version)
* Your connection string (remove any password)
* You server OS (with any SP) and Web Server Brand/Version
* The version of drivers (ODBC, Jet, ... what ever you use)
* Your version of Snitz
* Do you use any MODs, if yes which ones? Did you change the code otherwise?
* Did you check the links I've given above?
* How did you find the issue about topic.asp and/or include file?
* Did you ever tried to repair/compact your db?
* How many online users do you have at a time?
* Did you search the problem somewhere else (MS Knowledge Base etc)?
* Any other thing you want to mention?
Think PinkPost v40b03 Patches< |
|
|
|
stratacafe
Starting Member
Canada
44 Posts |
Posted - 27 February 2002 : 12:11:16
|
I'll answer what I can and put a call into my host for the others.
* Your database (brand, version)
The one that came with version 3.2 of the forums. I think it's an Access97 file.
* Your connection string (remove any password)
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../profiles/comments/snitz_forums_2000.mdb")
* You server OS (with any SP) and Web Server Brand/Version
I'll have to ask the host. I know it's Win2K with IIS 5.
* Your version of Snitz
Latest release version. I have made a few tweaks to the code. Namely, the ones found higher up in this thread.
* Do you use any MODs, if yes which ones? Did you change the code otherwise?
No mods. I did change the layout of the forums and the changes above.
* Did you check the links I've given above?
Yes.
* How did you find the issue about topic.asp and/or include file?
He got a specific error message once regarding that file. I made another change (regarding the order in which variables are declared in Topic.asp.) We haven't gotten the message since, but the load is still there.
* Did you ever tried to repair/compact your db?
No. Using the config on the site, It'll make the backup file, but it fails to overwrite the real one. I've tried to repair/compact it in Access2000, but the forum gave numerous errors with the new DB. I reverted to the old one.
* How many online users do you have at a time?
I would have to ask my host. I wouldn't guess more than 20 or so at a time. There are 1000 members on the forums, but only 300 of them are very active.
* Did you search the problem somewhere else (MS Knowledge Base etc)?
Yes. We even opened a ticket. MS's position is that it is a code issue, and they closed the ticket. That puts it back in my hands.
* Any other thing you want to mention?
Not really. Over the past few days we've been turning on and off different sections of the site and performing benchmarks. The server seems up to the task, and the rest of the site (that I wrote) runs quite nicely without the forums running. Is there a possibility that I'm hitting some sort of scalability issue with Access? My host is ready to install MySQL if Snitz supports it and I can transfer over the database, but I'm not sure if I can, or if that will alleviate the problem. That's plan B for now. =)
I'll get back to you about the other bits shortly. Any ideas so far?
< |
|
|
|
stratacafe
Starting Member
Canada
44 Posts |
Posted - 27 February 2002 : 13:05:13
|
Just heard back from my host:
* You server OS (with any SP) and Web Server Brand/Version
Windows 2000 SP2 Every available patch. Dell 2300 - 1GB RAM - 2 X 1.2Ghz processors - Hardware RAID (PERC) - Dual load balanced network cards w/RISC CPUs.
* The version of drivers (ODBC, Jet, ... what ever you use)
This is the Access ODBC drive 4.00.6019.00
* Any other thing you want to mention?
I currently have your site running isolated (High Application
Protection).
< |
|
|
|
stratacafe
Starting Member
Canada
44 Posts |
Posted - 27 February 2002 : 13:38:03
|
Answer to the one remaining question:
* How did you find the issue about topic.asp and/or include file?
Error: File /forum/topic.asp Script Engine Exception. A ScriptEngine threw expection 'C0000005' in '|ActiveScriptParse::ParseScriptText()' 'CActiveScriptEngine::AddScriptlet()'
This showed up in the Event Window at some point. Not sure if that was a definate pointer, or if it was just a coincidence.
About the recordsets not getting closed. Other than bug fixes posted to this board, I have not made any changes to the actual ASP. I have made some changes to the HTML to match the layout of my site, but otherwise the code is version 3.3.000? Whatever the current release is.
< |
|
|
|
Deleted
deleted
4116 Posts |
Posted - 27 February 2002 : 14:05:00
|
With that amount of hits there will be no problem. I think it is a version compatibility problem between A97 and the drivers on host. With 1.000 members and 10.000 posts the database must be real big (would like to know how much). That can really be the reason. If I were you, I would try the following:
1) Download the db (make a backup then), repair/convert it to Access 2000, compact it, upload it and try again. If this does not work:
2) Use a fresh (empty) database that comes with v3.3.03, convert it to Access 2000, upload it and test again...
I could not use the forum, it was down. Is it possible to make it up again but not to open to the public?
The error seems to be unrelated but I'll look at it.
Think PinkPost v40b03 Patches< |
|
|
|
stratacafe
Starting Member
Canada
44 Posts |
Posted - 27 February 2002 : 20:17:57
|
OK, converted to Access2000. Things SEEM to be running better. I say that because I've been at the "seem" stage several times over the past few days.
The forums are running now, but not long enough to have really generated any traffic. So we'll see.
The db isn't that big, was 9.2 mb, now 7.
The rest of the site runs off of a 32 mb database, so 9 should have been peanuts.
At the expense of sounding stupid (cause I'm a rank amateur at this) wouldn't it be faster overall if you sacrificed a little of the dynamic nature of the forums, wrote information like authors name and number of posts in each post, rather than trying to get all of that info all of the time. Seems like an awful lot of database calls for features of dubious worth.
Not that that has anything to do with this.
I'll have a better picture in an hour or two of how things are running.
< |
|
|
|
Deleted
deleted
4116 Posts |
Posted - 27 February 2002 : 21:16:36
|
quote:
The db isn't that big, was 9.2 mb, now 7.
The rest of the site runs off of a 32 mb database, so 9 should have been peanuts.
I hope everthing goes well. Don't forget that the database size nearly doubles whiþle the conversion process because the text data get converted to unicode. So the net size is 3.5. I advice you to compact it from time to time.
If the rest of the site also run on db, it will be a good idea to move to a faster database like SQL.
Think PinkPost v40b03 Patches< |
|
|
|
Topic |
|
Forum Locked
