| Author |
 Topic  |
|
|
BroIgnatius
New Member
56 Posts |
 Posted - 14 June 2007 : 07:37:37
|
I am not sure where to put this post.
Someone suggested to me that Access may not be adequate to handle a BBS system like this one once there are thousands of members and traffic. They said that it may be better to transfer over SQL or MySQL when things get really big.
I told him I would check with you guys are the relative value of SQL/MySQL databases vrs. Access database when the database becomes really huge.
|
Edited by - BroIgnatius on 14 June 2007 07:38:40 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 14 June 2007 : 07:44:20
|
| for large forums then yes you should use a SQL db rather than access, however the point at which changeover will give you benefits is rather subjective and depends largely on the performance of the server you are hosted on |
 |
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 17 June 2007 : 11:11:16
|
Yes, my preference is MSSQL Server, but I'd suggest not moving until you're sure you understand how MSSQL Server is a very different tool from Access! There are some great tutorials on the web, and good instructions on these forums for upgrading from Access to MSSQL Server.
You may be able to give your Access database a bit of a boost though by archiving old topics, then doing a 'compact and repair' on the db (you'll need to download the .mdb file locally first, do the compact, test it, and re-upload it) - it just helps remove legacy crud if you have any :) |
|
|
|
BroIgnatius
New Member
56 Posts |
Posted - 18 June 2007 : 13:10:19
|
Ok, thanks. I would probably use MySQL rather than MSSQL as MSSQL costs extra from my Web host, and MySQL doesn't.
But, this problem is a ways off, but good information to know when the time comes.
Thanks.
|
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 18 June 2007 : 13:36:33
|
| MySQL isn't bad, I still prefer MSSQL myself, but MySQL is worth every penny ;-) |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 18 June 2007 : 14:53:42
|
pdrg, are you trying to start something? 
(Please note, I also prefer MS SQL Server, but use MySQL where cost is an issue) |
Edited by - AnonJr on 18 June 2007 14:54:28 |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 19 June 2007 : 12:47:17
|
quote:
Originally posted by AnonJr
pdrg, are you trying to start something?
Heh stuff-per-penny MySQL and MSSQL Express are both rather tasty ;-) |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 19 June 2007 : 12:53:23
|
I'd finally gotten approval to use the Express Edition of SQL Server 2005, and Mr. Roadblock (name changed to protect my job) suddenly says, "oh, would you rather use the new full SQL Server we have had for a while?" Everybody else in the meeting (mostly people over in IS) looked at him like he'd spoken in toungs as nobody knew we'd even had it! Theoretically we'll be getting our server in the next week or so.
Back to something closer to the topic: yes, the Express Edition does quite well if you're on a budget (and you have somewhere to install it).
I'm also looking at using the stand-alone version of it as a substitute for JET in some of my desktop apps. |
Edited by - AnonJr on 19 June 2007 12:54:02 |
|
|
| |
Topic |
|
Topic Locked
