| Author |
 Topic  |
|
|
wax
Starting Member
4 Posts |
 Posted - 30 January 2004 : 14:58:13
|
Hey guys,
Recently switched to a dedicated box for my websites and the forum and so far it's just the forum running on it but there seems some sort of oddity, the main page of the forum takes some time to loadup whereas the subpages are fast, example:
main page: This page was generated in 2.12 seconds.
subpage: This page was generated in 0.09 seconds.
It's not the bandwidth / hosts connection as the page also shows up in those exact times (give or take a few ms. of course)..
I'm using a basic snitz install with 2 mods, events calendar (with recurring dates) which shows up on the main page and an avatar mod which isn't used until actually inside a post afaik .. I've tried removing the match calendar include from the main page which resulted in no speed gain so I'm kind of at a loss..
URL: http://klfclan.morphed.org/
Dbase: SQL Server 2000 with OLEDB conn string
CPU usage: never above like 10% when browsing the forum (only a couple of users anyways and not that many posts)..
Any ideas what I might do, or have done wrong ?
(Notes: There were 2 home made functions at the bottom of the page that relied on external sources but I have them turned off for the time being so you can ignore them)
|
|
|
Edwin1
Junior Member
107 Posts |
Posted - 30 January 2004 : 15:05:21
|
The forum loads fast to me but on the bottom : This page was generated in 16.48 seconds.
|
--Edwin |
 |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 30 January 2004 : 15:27:51
|
| Extremely slow for me, maybe the connection between the web server and sql server? |
The UK MkIVs Forum |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
NorwegianViking
Junior Member
Denmark
119 Posts |
|
|
wax
Starting Member
4 Posts |
Posted - 30 January 2004 : 16:55:57
|
I've tried with and without the calendar now it really doesn't seem to make a difference, so I thought I'd give access a go so I exported my tables etc. to the snitz access database, switched permissions and updated the config file, and voila, generation times of never more than a couple of MS..
Now sqlserver had low loading times but not constantly whereas on the access database it is constantly fast..
So I was all happy that I had atleast found a workaround but alas, replying to topics no longer works now because of some missing reply_id.. looks like it's gone completely buggerit so I'm gonna try a re-install of the forum and hopefully be able to copy back all the post data etc. too .. on Access that is
/EDIT:
NorwegianViking -- I'm fairly certain you got that when I was testing out Access :)
Note to all: I'm messing around with it so the link might be broke etc.
Thanks for the input so far though
|
Edited by - wax on 30 January 2004 16:56:46 |
|
|
|
PowerRun
Starting Member
5 Posts |
Posted - 09 February 2004 : 09:02:20
|
I migrated from Access to MySQL and experienced the same script-executiontimes as wax. On default.asp I get 2.2 sec, on all other pages it's <.6 seconds. The problem seems to be in the mod-check/sql, because it only happens when I'm logged on as admin/moderator. So maybe some smart guy knows why the queries are so slow on MySQL (and obviously on wax' MS SQL box as well).
I have no experience with MySQL, so I got no clue on this one. |
Edited by - PowerRun on 09 February 2004 09:03:20 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 09 February 2004 : 09:14:27
|
| The queries are not slow on MS SQL. Proof of that is this forum. What may happen is the connection from the web server to the SQL Server in a given host's environment. I think a similar thing can be said for MySQL, haven't read any complains from MySQL users. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
PowerRun
Starting Member
5 Posts |
Posted - 09 February 2004 : 09:41:22
|
Like I said, it's only:
- default.asp
- when logged on as admin/mod.
If I log out or log on as regular user, it's fast as it used to be on Access. I can duplicate these times when I want.
Logged on as ADMIN/Moderator:
Access: default.asp = .6 sec
MySQL: default.asp = 2.2 sec
Logged out:
Access/MySQL: default.asp = .5/.41 sec
I turned off all websites on this machine, just to test, but it's the same. And it's the same with 100 users or just me.
Config:
Snitz 3.4.03
Dual Xeon/ 2GB
Windows 2003
IIS6
MySQL 4.0.17-nt
MyODBC 3.51
|
Edited by - PowerRun on 09 February 2004 09:49:22 |
|
|
|
PowerRun
Starting Member
5 Posts |
Posted - 09 February 2004 : 11:33:31
|
Ok, I'm still in the dark why there's a difference between performance as mentioned above, but it has to do with allowing topic moderation.
Select Count(*) as PostCount FROM FORUM_REPLY R, FORUM_CATEGORY C, FORUM_FORUM F WHERE R.CAT_ID = C.CAT_ID AND C.CAT_MODERATION > 0 AND R.FORUM_ID = F.FORUM_ID AND F.F_MODERATION in (1,3) AND R.R_STATUS > 1
This one is done on default.asp (in inc_moderation.asp) and takes hella time on MySQL but not on Access. Conditions are in the post above. We don't use the topic-moderation option, so the problem can be solved by turning moderation off, but still I'm curious about the big why 
Any MySQL-expert who can shed some light on this? (and maybe the same goes for MS SQL)
|
|
|
|
jfitz
Junior Member
USA
345 Posts |
Posted - 09 February 2004 : 22:00:42
|
| If you are an admin or moderator, more SQL is going to be executed to prepare the default page for you to view vs a non-administrative member. Perhaps that explains some of the difference. |
--Jördan
It's a wasted day if you don't spend at least part of it flying upside down. |
|
|
|
PowerRun
Starting Member
5 Posts |
Posted - 13 February 2004 : 09:23:52
|
quote:
Originally posted by jfitz
If you are an admin or moderator, more SQL is going to be executed to prepare the default page for you to view vs a non-administrative member. Perhaps that explains some of the difference.
Yes. That's what I said. But why does MS Access run the same SQL faster than MySQL (prolly MS SQL as well)? |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 13 February 2004 : 20:38:44
|
| Is the MySQL Server on the same machine as the webserver ? If not then it's also got network traffic to contend with, Access doesn't suffer from that problem becuase your DB has to be on the same machine as the webserver. |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
| |
Topic |
|
Topic Locked
