| Author |
 Topic  |
|
|
RhinoOffRoad
New Member
USA
71 Posts |
 Posted - 14 September 2006 : 19:08:28
|
im once again concerned with board performance. to bring you up to date, i tried to switch over the mysql but couldnt get the latest release of mysql to play nice with windows, and i dont want to lose all the content in the access database anyway. when i archived my board it helped a lot, but now i have a scoundrel doing redundant archive searching to purposefully bring my board to a halt. i disabled searching, but if users cant search my archives then they may as well not even be there anymore.
im currently running on a dedicated server in a datacenter with a 1.4 gig processor and 512 megs of ram. i plan to build an undated server and host out of my home on a 3mbps upstream commercial cable connection. as i prepare to buy parts for my server, im wondering just how much hardware i need in order to enable archive searching without bringing the rest of the board to a complete stop until the searching is completed. when i host local ill be running on windows 2000 server (since i have a copy thats paid for) utilizing the existing access database.
i want to build a server thats fast enough for reasonable demands both today and tomorrow without spending more than is necessary.
......so, what processor is necessary to enable searching while still serving pages? how much ram is necessary?
thanks, |
Nathan In Montana
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 14 September 2006 : 19:34:26
|
well, searching your database should not really affect the performance of the rest of the forum.
How big is your database ? how many concurrent users do you get ? any idea how much of your 512Mb is being used by your website ?
How much do you want to spend ? |
 |
|
|
RhinoOffRoad
New Member
USA
71 Posts |
Posted - 14 September 2006 : 19:46:56
|
quote:
Originally posted by HuwR
searching your database should not really affect the performance of the rest of the forum.
it brings the rest of the forum to a halt. in fact i have a half dozen or so forums on the same server (only 1 is busy though) and you cannot browse any of the pages from any of the forums during an archive search of my main forum.
quote:
How big is your database ?
the database is currently 102 megs, and i also have a *.bak file (dont recall where it came from) that i believe is a backup of my db at 163 megs.
quote:
how many concurrent users do you get ?
it varies but this isnt an issue. i can log into the site at 4am when nobody else is on and it still brings the rest of the forum to a halt during archive searching.
quote:
How much do you want to spend ?
only as much as i have to in order to get the performance im looking for, which is why im asking what the recommended requirements would be. i suppose i could build a multi-processor machine, but dont want to if i dont have to.
thanks, |
Nathan In Montana
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 15 September 2006 : 04:13:53
|
I'd also recommend restricting the search to members only to prevent this person from using it.
|
 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.” |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 15 September 2006 : 05:10:17
|
| basically your problem is most likely access and a lack of ram. when you say you couldn't get mysql to work, what problems were you having ? it should work fine with windows, and you also shouldn't lose any of your existing content when moving |
|
|
|
RhinoOffRoad
New Member
USA
71 Posts |
Posted - 15 September 2006 : 11:55:47
|
quote:
Originally posted by Shaggy
I'd also recommend restricting the search to members only to prevent this person from using it.
hes coming at me from different IPs from different ISPs each time. |
Nathan In Montana
|
|
|
|
RhinoOffRoad
New Member
USA
71 Posts |
Posted - 15 September 2006 : 11:58:18
|
quote:
Originally posted by HuwR
when you say you couldn't get mysql to work, what problems were you having ? it should work fine with windows
perhaps ill play with it again once im back on a local server.
quote:
you also shouldn't lose any of your existing content when moving
ive heard its a "nightmare" to convert from access to mysql. your thoughts on that?
thanks, |
Nathan In Montana
|
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 15 September 2006 : 12:01:08
|
quote:
Originally posted by RhinoOffRoad
ive heard its a "nightmare" to convert from access to mysql. your thoughts on that?
There's a very well written guide stickied in the MySQL forum here which should be of use to you.
|
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.” |
|
|
| |
Topic |
|
Topic Locked
