| Author |
 Topic  |
|
|
johnny bravo
New Member
78 Posts |
 Posted - 02 September 2006 : 11:21:24
|
I'm currently using an access database but often get a database in use when using the forum. We have a lot of memebers and I think we have out grown access.
My main question is is their a limit to how big the access database should be, mine is about 8mb at the moment.
Also would somebody like to do the transfer from access to SQL for me if I paid them and how? can you email me on jonathan.kettle@gmail.com if you are intrested.
Link to the fourm is here www.elvethamheathfourm.info
Hosted on 1and1
Many Thanks
Johnny B |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 02 September 2006 : 11:41:15
|
8 MB is very small. That won't mean that Access can handle all the simultaneous users your forum has, if it has many simultaneous users.
Forum performance should be the key indicator for the move, not database size. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
johnny bravo
New Member
78 Posts |
Posted - 02 September 2006 : 12:59:30
|
Thanks for the advise
we have anything from 5 to 35 people on at any one time
This is the most common error I get
Microsoft JET Database Engine error '80004005'
Could not use ''; file already in use.
/forum/inc_header.asp, line 133
JB |
Edited by - johnny bravo on 02 September 2006 13:00:03 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 02 September 2006 : 21:03:52
|
At the same time, 5-35 users shouldn't really have that impact. When my forum was on Access it could handle a lot more than that.
I moved away from Access when my database was close to 200Mb but you have to balance the database size against the concurrent user count against what else is running on the server (you have no control over this last bit).
Moving to SQLServer or mySQL will help solve your problems. |
|
|
|
spyderuk
Junior Member
United Kingdom
211 Posts |
Posted - 24 September 2006 : 07:14:25
|
Access still holding out for me on the following stats. DB size around 25mb. I've never seen or had reports of that error.
Active Members: 3 | Guests: 2 | Total: 5 [ Administrators | Moderators ]
Active Users Record: 42 | Record Set On: 05/06/2006 at 21:28:28
You last visited on Today 11:17:07
379 of 638 Members have made 14320 posts in 21 forums, with the last post on Today 12:18:36 by: Lil Beckz.
There are currently 1245 topics and 8 active topics since you last visited.
There are 16117 archived posts in 2195 archived topics
I've found my new host and planning a conversion around November / December. Let us know how easy/hard the conversion was. I'm concerned about the mods I have installed causing problems  |
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 
|
|
|
| |
Topic |
|
Topic Locked
