| Author |
 Topic  |
|
|
Aaron S.
Average Member
USA
985 Posts |
 Posted - 19 February 2007 : 11:08:16
|
My site POTF2.COM is pretty slow at times in the forums.
I use MS Access and the database is about 250MB.
The site is on a dedicated machine that has 512MB RAM.
What are some tips for improving performance? What would be better increasing RAM by another 512MB, switching to SQLServer or MySQL, other?
Thanks,
--Aaron |
DOWNLOAD GREAT NEW MODS HERE |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 19 February 2007 : 11:10:10
|
| the only way to really improve performance if you have a 250Mb Access DB is to NOT use access, switch to MySQL or MS SQL |
 |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 19 February 2007 : 11:10:26
|
My personal recommendation would be, at 250M, to switch to a different database.
Welcome back, by the way, Aaron 
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 19 February 2007 : 14:55:49
|
| Just to check, have you compacted the db recently? Archived? Both of those could give you some benefit, and may buy you some time whilst you consider the upgrade option! |
|
|
|
Aaron S.
Average Member
USA
985 Posts |
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 19 February 2007 : 16:34:06
|
ahhh - that gives a good clue - always hangs = timeout most likely = why you've got speed problems
Can you increase the timeout (temporarily) on the db connection to something like 30 mins (and make sure the session and script timeouts are the same - it's only a one-off) and try archiving again?
Alternatively, shut the forum for a few hours, download the db locally, and with your local connection set to 30' (instead of the default 90s) run the archive locally, then compact the db and re-upload it to your site.
I have a hunch you'll be pleasantly surprised :) |
|
|
|
Aaron S.
Average Member
USA
985 Posts |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 19 February 2007 : 17:21:06
|
| What about archiving in smaller chunks? Maybe you can nibble away at it until it gets back to this side of manageable... |
Edited by - AnonJr on 19 February 2007 17:21:50 |
|
|
|
Aaron S.
Average Member
USA
985 Posts |
Posted - 19 February 2007 : 19:37:59
|
What is weird (or maybe not) is that I have another forum site running from the same database.
BehindTheToys.com uses the same Access file. It shares the member table and then has its own tables for topics/replies.
It is very fast. It is the main site, POTF2.COM, that slows way down.
POTF2.COM has many more topics/replies and many more active users, so that is probably why it is so much slower.
Thoughts?
--Aaron
|
DOWNLOAD GREAT NEW MODS HERE |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 19 February 2007 : 19:50:10
|
quote:
POTF2.COM has many more topics/replies and many more active users, so that is probably why it is so much slower.
yes that is the reason, it is not the fact that the db is 250Mb that is the problem, but just that access is not really a good database for serving up lots of queries at the same time, especially if it has to find that information in such a large unstructured file like the mdb file, it is really only meant and designed to be a desktop database (ie only accessed by one person) |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 20 February 2007 : 11:00:24
|
| yep, you need to nibble away at the archiving, this should be your first priority. If the other site is still fast, it suggests you're not overwhelmed on the #concurrent users, so once archived you can probably carry on using the self-same Access db for a while yet |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 20 February 2007 : 14:29:40
|
Though, an upgrade sometime in the near future probably wouldn't be out of order...  |
|
|
| |
Topic |
|
Topic Locked
