Author |
Topic  |
|
spyderuk
Junior Member
 
United Kingdom
211 Posts |
Posted - 19 February 2006 : 16:37:51
|
I have searched around and discovered that an Access DB will only support so many users at one time. Does anyone have any idea on how many users can be supported? |
Snitz 3.4.05. Mods Installed, Additional Smilies, Poll's, PM's, Email All Users, Today/Yesterday, Active Users 4, Portal Mod, My Own Google, Referer Mod, Avatars, Intergrated Conqueror Chat, Usergroups, IPGate, File Attachment Mod & Image Resize Mod.
Next Mod? My Snitz Forum 
|
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
Posted - 19 February 2006 : 16:50:27
|
Search around a little more and you will that really depends on the server, on how much memory it has, on the hardware it runs, on the overall web server load and such... No easy answers... |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
spyderuk
Junior Member
 
United Kingdom
211 Posts |
Posted - 19 February 2006 : 17:01:48
|
Cheers Rui. I'm in the archives now  I think I'm ok for now - 42 of 69 Members have made 1377 posts in 18 forums. Just thinking if I need to do the upgrade may be best to get it done sooner rather than later. Whilst on the subject, both SQL DB's have to be paid for right? |
Snitz 3.4.05. Mods Installed, Additional Smilies, Poll's, PM's, Email All Users, Today/Yesterday, Active Users 4, Portal Mod, My Own Google, Referer Mod, Avatars, Intergrated Conqueror Chat, Usergroups, IPGate, File Attachment Mod & Image Resize Mod.
Next Mod? My Snitz Forum 
|
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
|
spyderuk
Junior Member
 
United Kingdom
211 Posts |
Posted - 19 February 2006 : 17:51:07
|
My current host is £199 per year for 100mb SQL although they don't state whether MS or MY! They have been good so far as I had really bad site access over the weekend. Email sent to support and it was fixed within an hour. Someone abusing bandwidth Didn't expect a reply till monday morning. On page 12 of 65 in the archives Seems it does vary a lot but on my current forum it's only 2mb so i think it seems quite low.
|
Snitz 3.4.05. Mods Installed, Additional Smilies, Poll's, PM's, Email All Users, Today/Yesterday, Active Users 4, Portal Mod, My Own Google, Referer Mod, Avatars, Intergrated Conqueror Chat, Usergroups, IPGate, File Attachment Mod & Image Resize Mod.
Next Mod? My Snitz Forum 
|
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
|
spyderuk
Junior Member
 
United Kingdom
211 Posts |
Posted - 19 February 2006 : 18:08:55
|
quote: Originally posted by ruirib
For that price probably MS. Easy to upgrade when required.
Did you see the price? Out of my budget I'm afraid. |
Snitz 3.4.05. Mods Installed, Additional Smilies, Poll's, PM's, Email All Users, Today/Yesterday, Active Users 4, Portal Mod, My Own Google, Referer Mod, Avatars, Intergrated Conqueror Chat, Usergroups, IPGate, File Attachment Mod & Image Resize Mod.
Next Mod? My Snitz Forum 
|
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
|
alanh
New Member

United Kingdom
92 Posts |
Posted - 20 February 2006 : 10:18:08
|
Most hosts will probably just charge you a set up fee to enable SQL and add it to your existing package, at no extra cost. Well mine will........ I just read their blurb on it.
I am currently running with an access database which is 8Meg in size. I only have 70 forum members at present, but it is a specialised forum. Never had any problems with concurrent connections, but then again my maximum has only ever been 15.
Hope these figures help. |
Edited by - alanh on 20 February 2006 10:21:20 |
 |
|
spyderuk
Junior Member
 
United Kingdom
211 Posts |
Posted - 20 February 2006 : 14:49:45
|
Thanks all for the replies. I've gained another 2 members. The subject of my forum could mean it's going to get really busy or it could just plod along. I'm not sure which way it's going to go but we will have to wait and see. 
I'm gonna stick with access for now and do my regular archiving and pruning to keep things in order. Maybe use it as a test to see how much stick access can take.
Slightly off topic but still access. Could I edit deleted members directly in the DB from n/a's to Deleted Member without causing havoc? They still seem to show in the members list  |
Snitz 3.4.05. Mods Installed, Additional Smilies, Poll's, PM's, Email All Users, Today/Yesterday, Active Users 4, Portal Mod, My Own Google, Referer Mod, Avatars, Intergrated Conqueror Chat, Usergroups, IPGate, File Attachment Mod & Image Resize Mod.
Next Mod? My Snitz Forum 
|
 |
|
AnonJr
Moderator
    
United States
5768 Posts |
Posted - 20 February 2006 : 14:51:39
|
I'd have to concur with that. On my public forum, which is Access-based, we top out at about 6 or 7 concurrent users and haven't had a glitch. On the work forum, behind the firewall, we get a lot more and have had various problems.
My host just added MS-SQL to all its packages to stay competitive and I've been thinking of upgrading now when I've only got a small number of users to worry about interrupting, instead of waiting until I need to upgrade...
HTH. |
 |
|
spyderuk
Junior Member
 
United Kingdom
211 Posts |
Posted - 20 February 2006 : 14:57:10
|
Most active users so far was 9 with no problems. I also get hit by spiders quite often. MS has been in and I turn up on page 1 of MSN search without submitting?
Please ignore the deleting of members found I can edit the in their profile or delete them if all their post's are deleted. |
Snitz 3.4.05. Mods Installed, Additional Smilies, Poll's, PM's, Email All Users, Today/Yesterday, Active Users 4, Portal Mod, My Own Google, Referer Mod, Avatars, Intergrated Conqueror Chat, Usergroups, IPGate, File Attachment Mod & Image Resize Mod.
Next Mod? My Snitz Forum 
|
 |
|
spyderuk
Junior Member
 
United Kingdom
211 Posts |
Posted - 04 May 2006 : 16:31:35
|
Ok sorry for the ressurection but I thought I would post the latest info Active Users Record: 24 | Record Set On: 19/04/2006 at 14:15:13 161 of 237 Members have made 5427 posts in 18 forums, with the last post on Today 21:30:25 by: Admin. There are currently 569 topics and 9 active topics since you last visited. There are 3164 archived posts in 496 archived topics Access database still holding out with no noticable performance issues. Archived at the beggining of the month. Database size now 11.27Mb
|
Snitz 3.4.05. Mods Installed, Additional Smilies, Poll's, PM's, Email All Users, Today/Yesterday, Active Users 4, Portal Mod, My Own Google, Referer Mod, Avatars, Intergrated Conqueror Chat, Usergroups, IPGate, File Attachment Mod & Image Resize Mod.
Next Mod? My Snitz Forum 
|
Edited by - spyderuk on 04 May 2006 16:36:49 |
 |
|
|
Topic  |
|
|
|