Author |
Topic |
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 29 December 2000 : 09:36:12
|
Well its time for me to throw in my $0.02 also. I think that closing that one connection will not crash the server either and if one connection is used through out the page it will not be a problem since the connection will end at the end of the script running also. I have read a lot of books and things saying that the following script takes longer to load.
<% End IF %> <% End IF %> <% End IF %> <% End IF %>
I was told that every time you tell it to switch between html and asp code you consider it adding a very very very small amount of time to the time the page loads. With this in mind I would think that if we are trying to get Snitz Forum to run as fast as we can, why can’t we use Response.Write instead of switching to html? I might have been misinformed so please let me know your comments.
Brad
|
|
|
tilttek
Junior Member
Canada
333 Posts |
Posted - 29 December 2000 : 11:45:23
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> I was told that every time you tell it to switch between html and asp code you consider it adding a very very very small amount of time to the time the page loads. With this in mind I would think that if we are trying to get Snitz Forum to run as fast as we can, why can’t we use Response.Write instead of switching to html? I might have been misinformed so please let me know your comments. <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Your right, and it's one major point that make Snitz a litle slow. You don't see it when there is not much user, but I did some modifiction on version 3 and could get 15% to 25% more... When hammering the server... Try with 10, 20, 30, 50, 100, 150, 200 and 250 users at the same time. All this unser 10 sec... Let say with 250 could get very far. Even with 200... But When I change the code... 200 was ok. and 250 was a litle over my line, but was ok.
Philippe Gamache http://www.tilttek.com http://www.lapageamelkor.com |
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 29 December 2000 : 12:17:40
|
Well if this is the case I can spend some time this weekend converting the entire Snitz forum using Response.Write, is this something I should even do? do you think HuwR would update the download file so that everyone's forum would be running much faster?
Brad |
|
|
John
Junior Member
USA
427 Posts |
Posted - 29 December 2000 : 13:06:47
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> Well if this is the case I can spend some time this weekend converting the entire Snitz forum using Response.Write, is this something I should even do? do you think HuwR would update the download file so that everyone's forum would be running much faster? <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
First of all, Mike and Gor are the head admins, who update the download file.
Also, Mike is currently sort of rewriting the code to use CSS and internationalization, so no mods or anything like that will be incorporated into the code until that is complete.
<b><font size=2>John Miller</font id=size2> <font color=green>Snitz Moderator</font id=green></b> <img src="http://www.forum.snitz.com/forum/icon_star_gold.gif" border=0><img src="http://www.forum.snitz.com/forum/icon_star_gold.gif" border=0> |
|
|
Shade
Starting Member
Indonesia
15 Posts |
Posted - 29 December 2000 : 18:32:30
|
My forum record about 1000 post every week and have 650+ member. My IIS always crash about every four days and show error message "[Microsoft][ODBC Microsoft Access]System Resource Exceeded". I have to reboot the server before the IIS can run properly again. Dunno if this have something to do with opened connection that not closed. This kind of error never happen before. It happen after my forum get about 8000 hits a day. I have not added any mod on my forum.
I can't find what's wrong with it so I decided to upgrade my forum to use MySQL.
Edited by - shade on 29 December 2000 18:34:14 |
|
|
brkonthru
Development Team Member
Jordan
69 Posts |
Posted - 30 December 2000 : 06:14:09
|
The error you are seeing might be related to the fact that you are using an Access DB.
Access was designes with only 15-20 users conneting to the DB at the same time. This could be your problem, or one of the elements of it.
jeeran.com ------------------- free hosting, free email, calendar, and snitz all in one! |
|
|
tilttek
Junior Member
Canada
333 Posts |
Posted - 03 January 2001 : 16:12:30
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> Well if this is the case I can spend some time this weekend converting the entire Snitz forum using Response.Write, is this something I should even do? do you think HuwR would update the download file so that everyone's forum would be running much faster? <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Hi, I this I will be something that sould be done. For my part, I did modify the color, so we are using a Special Tag system that change the code itself. So we did reduce access time. So insted of <pre id=code><font face=courier size=2 id=code><% = strDefaultColor %> We have <@b& strDefaultColor &b@></font id=code></pre id=code>
Then the file is parse and save on the server.
So in the ASP file you directly have <pre id=code><font face=courier size=2 id=code> <FONT COLOR="#FF0000"> </font id=code></pre id=code>
It's quite nice to have!
Philippe Gamache http://www.tilttek.com http://www.lapageamelkor.com |
|
|
korrupt
New Member
USA
55 Posts |
Posted - 07 February 2001 : 13:55:07
|
quote: If restarting your virtual server helps, then the problem may lie in your scripts. The situation usually occurs as a result of large number of exceptions in the MTX component running the virtual server. To avoid this problem (or at least minimize it), please check your code and make sure that all external objects are explicitly destroyed after being used, use err object after each call to external objects (esp. after calls to database connection objects). In many cases repairing databases used on the backend helps to increase the speed significantly.
I originally posted this in the mods support forum but I didn't know this topic existed. Does this make sense to anybody or is my isp just trying to BS me? I'm currently running 3 forums, they don't get hit too often and are running on an access database. 2 of them are Huwr's combined mod forums. This all started when my virtual server started running EXTREMELY slow.
Reach for What You Want The Racism Discussion Forum http://www.korrupted.net/racism |
|
|
brkonthru
Development Team Member
Jordan
69 Posts |
Posted - 07 February 2001 : 14:24:44
|
I predicted this and warned about it looong time ago! Snitz would develop a bad reputation among ISP's because it sucks up too much power from the server.
|
|
|
korrupt
New Member
USA
55 Posts |
Posted - 07 February 2001 : 14:40:02
|
Well, I dont think it was the "Actual" snitz forum that was causing this problem. If so, this would have happened when I FIRST installed the racism forum. This started happening as soon as I added 2 new forums from Huwr with the mods already integrated and also added annoucements, private messages, and active users to the current racism forum. So, if anything, it's just these mods being coded in such a way that they're causing server slowdowns. Even that I can't argue since I don't program in asp and therefore not able to look at the code and be able to tell if something is being closed or not. That's why I originally posted to see what the people with asp experience thought.
Reach for What You Want The Racism Discussion Forum http://www.korrupted.net/racism |
|
|
brkonthru
Development Team Member
Jordan
69 Posts |
Posted - 07 February 2001 : 15:20:46
|
Well, you are reffering to something else. And I believe your problem has nothing todo with the original snitz code. The kind of load im talking about happens when there are a lot of messages and there are a lot of people accessing the site.
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 07 February 2001 : 16:41:06
|
with using the active users mod it access the database everytime someone views a page a couple of times i think. this can cause the page to seem to run slow if using access.
my site used to also be very slow because i was being hosted on a load balanced servers. when i got them to put my on the sql server site so i wouldnt have to go thru there network just to access the database my site speed has not yet once slowed down.
just a fyi
Brad |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 07 February 2001 : 17:23:03
|
Adding all the mods will certainly slow down your response times, most of them are fetching or writing information to the database.
I've checked through my forum files. The pollmentor functions were not closing their db connections correctly in all circumstances, I have removed all the code and replaced using my_conn. I have also done the same in pop_profile, which had a non closed connection.
here are the files
if that doesn't make any difference, then it is nothing to do with unclosed connections.
'Resistance is futile' |
|
|
pk_zone
New Member
Canada
69 Posts |
Posted - 07 February 2001 : 19:45:55
|
Just to add more fuel to the fire....
I run Snitz on a Win 2K box with a PII 400 / 256 MB RAM, IIS hosting 3 websites with no slowdowns at all, plus all 3 sites are using access db's (These db's are on separate machines). True, there is not a lot of traffic, maybe 500 users/day on each of the forums but I don't see why some of you are having problems with Snitz. I think it's more to do with the way your hosting servers are set up and what they are hosting/running.
I can only speak from my own experience with hosting Snitz on my server and I have had zero problems.
Cheers!
PK
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 07 February 2001 : 19:54:44
|
quote:
Just to add more fuel to the fire....
I run Snitz on a Win 2K box with a PII 400 / 256 MB RAM, IIS hosting 3 websites with no slowdowns at all, plus all 3 sites are using access db's (These db's are on separate machines). True, there is not a lot of traffic, maybe 500 users/day on each of the forums but I don't see why some of you are having problems with Snitz. I think it's more to do with the way your hosting servers are set up and what they are hosting/running.
I can only speak from my own experience with hosting Snitz on my server and I have had zero problems.
Cheers!
PK
I would tend to agree, the server with my two test sites has about 10 sites, 2 more snitz forums as well as my test sites, one of these is very busy.
Anyway, the server runs fine, but crashes completely about twice a week, I have done extensive monitoring and checks, and the culprit is not any of the snitz forums, but a microsoft commerce shop, and microsoft admanager.
ANother point which I checked in my testing, I connected 36 simultaneous users (using a custom built delphi app) to our server and opened a page which opened but did not close it's db connection, all 36 of these sessions were refreshed every 30 secs, the server didn't even hickup.
'Resistance is futile' |
|
|
Topic |
|