| Author |
 Topic  |
|
tomfassett
Starting Member
USA
35 Posts |
 Posted - 01 September 2006 : 02:16:03
|
And now the $64,000 question.  I have been told that there is a severe limitation using an Access database--namely the number of simultaneous users and speed limitations. Any truth to this? The forum has over 1000 members of which a few hundred are regularly active and the database in in the 65mb size range. Am I heading for trouble if I keep using the Access database?
Tom F |
 |
|
|
Jarrek
Starting Member
17 Posts |
Posted - 29 November 2006 : 00:46:43
|
quote:
And now the $64,000 question. I have been told that there is a severe limitation using an Access database--namely the number of simultaneous users and speed limitations. Any truth to this? The forum has over 1000 members of which a few hundred are regularly active and the database in in the 65mb size range. Am I heading for trouble if I keep using the Access database?
The simple answer is yet. But it all depends.
I had the forums ran on a soley dedicated server - Celeron 1.7, 80GB, 512MB RAM, and when our Access database got to 250MB, the server started to stall. W3WP usage was all pretty constant at 60-70% at peak times.
I switched over to MySQL and the improvement in access times is simply unreal. Pages now load in as fast as 0.1 seconds! The server doesn't stall, the database is WAY smaller - only about 100MB. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 29 November 2006 : 06:11:37
|
| If MySQL is only about 100 MB, that likely means the Access DB could be compressed to quite a smaller size, as well. Of course, the move to MySQL is still advised and performance better than with Access, but DB size, in MySQL, if anything, should be higher, not smaller. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Jarrek
Starting Member
17 Posts |
Posted - 29 November 2006 : 14:24:10
|
Ruirib,
Previous compacted Access DB size was 236MB.
I made a mistake when stating the current MySQL DB size, apologies.
MySQL: The Data portion is 185 MB and the Index is 28 MB, total of 213 MB.
The huge difference is CPU utilization. About 50-60% less than before.
To sum it up - worth the switch.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 29 November 2006 : 14:26:59
|
Ok, that makes much more sense. The access DB probably hadn't been compacted to a smaller size for some time, cause it should be smaller than MySQL.
Anyway I do agree with you - the move to MySQL is always justifiable when Access starts to have troubles handling the extra traffic. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 30 November 2006 : 11:41:12
|
| Tomfasset, if you also have MS SQL Server available, and you're already paying for it, you could try upgrading to that instead. It would be my personal choice over MySQL or Access |
|
|
|
Topic |
|
Topic Locked
