| Author |
 Topic  |
|
|
garyrobar
New Member
Canada
90 Posts |
 Posted - 20 May 2006 : 11:19:02
|
I have concerns about the access database being able to handle large numbers of posts. has anyone actually had their forum outgrow an access database?
if not, is anyone operating a very large forum and the access db is still working fast and well? |
SEO For Snitz Forum |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 20 May 2006 : 11:26:56
|
The terms "Fast" and "grow well" aren't usually found in the same sentence as Access...
In truth, Access isn't the best for a large and/or well-trafficked web site. Having said that, with some care and thought you can take Access quite far. Eventually though, you will outgrow Access unless your traffic is a trickle.
Again, due to the large number of variables its hard to give concrete figures. |
 |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 21 May 2006 : 06:22:13
|
quote:
has anyone actually had their forum outgrow an access database?
Yes I was on Access and had to move on. I chose SQL Server, although for personal reasons I wish I had chosen mySQL. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 21 May 2006 : 06:29:03
|
| A busy forum will eventually outgrow Access. How soon will that occur? Depends on the number of posts and the number of users simultaneously online. If you are expecting many simultaneous users online, Access may not be able to handle it at all, regardless of DB size. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
garyrobar
New Member
Canada
90 Posts |
Posted - 15 November 2006 : 22:11:18
|
Thanks everyone for the replies. It should be fine for now while my forum is just in its baby stages.
Has anyone here made a conversion at any point? IE: was using access, outgrew it, and propped all of their data to a faster/better DB format? |
SEO For Snitz Forum |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 16 November 2006 : 03:59:19
|
There are many posts covering such conversions in the MySQL & MSSQL forums.
|
 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.” |
|
|
|
Ticktock
Starting Member
39 Posts |
Posted - 19 November 2006 : 13:16:28
|
I was on Access for a good few years. It was only this year that my host pulled the plug for me taking up too many file handles. Around this time, I was starting to experience all manner of record locking and timeout issues. The size of my database was over 200MB and I therefore had to move to MySQL. It's been wonderful ever since  |
|
|
| |
Topic |
|
Topic Locked
