| Author |
 Topic  |
|
|
buksida
Starting Member
Thailand
21 Posts |
 Posted - 25 October 2005 : 02:11:12
|
We have had the forum running for about a year, its version 3.4.04, it has around 72,500 posts and 4,000 topics in total.
The last couple of weeks or so its gradually slowed down and now each page takes a good 15-20 seconds to open.
Is this a server problem (the rest of the site is fine) or are there any tweaks that can be done to the board to get it back to normal speed?
|
|
|
slapmonkay
Starting Member
22 Posts |
Posted - 25 October 2005 : 04:33:10
|
| What kind of database do you use, If you have used MSAccess after the database gets so big it tends to run slowly you will have to change it over the SQL or other type of database if this is the case. |
 |
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 25 October 2005 : 05:01:13
|
72,500 posts is a pretty healthy size - have you tried archiving, see if that improves things at all??
Also, as slapmonkay suggests, it may be time to move to a more powerful db engine... |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 25 October 2005 : 09:47:58
|
| Just FYI for those who didn't know, Access gets a serious performance hit after about 50k records. I was running into a problem with an online testing program I wrote and in my research came across that fact. If you are running Access I'd definatly upgrade to SQL Server or MySQL. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 25 October 2005 : 10:22:12
|
quote:
Originally posted by AnonJr
Just FYI for those who didn't know, Access gets a serious performance hit after about 50k records. I was running into a problem with an online testing program I wrote and in my research came across that fact. If you are running Access I'd definatly upgrade to SQL Server or MySQL.
Frankly, I don't think it depends on the number of records. It varies too much, but I've seen DBs with 200,000 replies performing faster than SQL Server, for some queries...
I would archive topics, compact the DB and check if that would help. Anyway, migration should be a need sooner or later. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 25 October 2005 : 11:19:51
|
I think the implication in the article was 50k in a given recordset, but I could be mistaken. If I understand right, when you archive a topic it gets moved to a different table; therefore mitigating that problem.... I could be mistaken and welcome any corrections. MS doesn't exactly have the clearest documentation in the world  |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 25 October 2005 : 13:30:35
|
I'm sure that since the article wasn't a KB article or a technical paper they probably rounded it for the benefit of a good even number. Like I said, MS isn't exactly well known for clairity in their information.
If I can find the article again I'll link to it.
Either way an upgrade is in order  |
|
|
|
buksida
Starting Member
Thailand
21 Posts |
Posted - 26 October 2005 : 04:52:29
|
Its an SQL database so should be able to handle it right?
I'll try the archive and see how it goes. Are archived posts not available for viewing? How does it work abd where is it (couldnt find in the Admin section)
|
Edited by - buksida on 26 October 2005 04:54:43 |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 26 October 2005 : 06:16:34
|
| SQL Server should be able to handle it. If you've got a lot of old topics some judicious archiving would go a long way. It's in the Admin Options if I remember right (Listed as "Archive Forum Topics"). |
|
|
|
gpspassion
Junior Member
260 Posts |
Posted - 08 May 2006 : 13:10:01
|
| Did it help ? When there are too many people browsing my dual Xeon setup just can't keep up. |
|
|
| |
Topic |
|
Topic Locked
