Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 Bad and Sloppy Coding.
 New Topic  Topic Locked
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 3

redbrad0
Advanced Member

USA
3725 Posts

Posted - 29 December 2000 :  09:36:12  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
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
Go to Top of Page

tilttek
Junior Member

Canada
333 Posts

Posted - 29 December 2000 :  11:45:23  Show Profile  Visit tilttek's Homepage
<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
Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts

Posted - 29 December 2000 :  12:17:40  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
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
Go to Top of Page

John
Junior Member

USA
427 Posts

Posted - 29 December 2000 :  13:06:47  Show Profile
<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>
Go to Top of Page

Shade
Starting Member

Indonesia
15 Posts

Posted - 29 December 2000 :  18:32:30  Show Profile  Visit Shade's Homepage
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
Go to Top of Page

brkonthru
Development Team Member

Jordan
69 Posts

Posted - 30 December 2000 :  06:14:09  Show Profile  Send brkonthru an ICQ Message
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!
Go to Top of Page

tilttek
Junior Member

Canada
333 Posts

Posted - 03 January 2001 :  16:12:30  Show Profile  Visit tilttek's Homepage
<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
Go to Top of Page

korrupt
New Member

USA
55 Posts

Posted - 07 February 2001 :  13:55:07  Show Profile  Visit korrupt's Homepage  Send korrupt an ICQ Message  Send korrupt a Yahoo! Message
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
Go to Top of Page

brkonthru
Development Team Member

Jordan
69 Posts

Posted - 07 February 2001 :  14:24:44  Show Profile  Send brkonthru an ICQ Message
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.



Go to Top of Page

korrupt
New Member

USA
55 Posts

Posted - 07 February 2001 :  14:40:02  Show Profile  Visit korrupt's Homepage  Send korrupt an ICQ Message  Send korrupt a Yahoo! Message
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
Go to Top of Page

brkonthru
Development Team Member

Jordan
69 Posts

Posted - 07 February 2001 :  15:20:46  Show Profile  Send brkonthru an ICQ Message
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.

Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts

Posted - 07 February 2001 :  16:41:06  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
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
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 07 February 2001 :  17:23:03  Show Profile  Visit HuwR's Homepage
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'
Go to Top of Page

pk_zone
New Member

Canada
69 Posts

Posted - 07 February 2001 :  19:45:55  Show Profile  Send pk_zone an ICQ Message
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

Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 07 February 2001 :  19:54:44  Show Profile  Visit HuwR's Homepage
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'
Go to Top of Page
Page: of 3 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.19 seconds. Powered By: Snitz Forums 2000 Version 3.4.07