| Author |
 Topic  |
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
 Posted - 25 November 2003 : 04:03:48
|
| Is MS SQL really faster, or is it just a matter of better performance, when lots of users are online at the same time? |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 25 November 2003 : 04:10:56
|
| it is a matter of better performance and scalability for large databases, don't forget that 99% of the time the SQL will be sitting on a seperate server, so you have a network in between to slow things down, so on a one on one basis access should beat SQL every time as it is only local disk access, but give them a big database and a complex query and SQL will come out top. |
 |
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 25 November 2003 : 05:50:54
|
| How big is big ? My database is a little over 30MB, 800 members and almost 60000 posts. |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 25 November 2003 : 06:42:44
|
| 30Mb's not that big, I've seen folks with 100Mb Access DB's still running well, but then they probably only have 2 or 3 users online at any one time too. |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 25 November 2003 : 06:51:06
|
As gremlin said 30Mb is pretty small, but it is todo with how busy it is that is most important.
Also don't forget that on a web server the access db is most likely sharing drive access with many other websites |
|
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 25 November 2003 : 06:52:42
|
| My max online users in 3 years is 16 people, but normally it´s not more than 10 users online. Does this mean that with my current database there´s no need to use MSSQL ? |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 25 November 2003 : 07:15:43
|
| If it was me, I'd probably stick with access, Even with 10-20 users online, the chance of them all hitting a link at the same time is probably not all that high, most of the time forum users sit there reading posts and only occasionally hitting the DB when they load their next topic or page, or perhaps post one of their own, making the actual simultaneous access to the database generally quite a bit lower than the number of simultanous users on the website. |
Kiwihosting.Net - The Forum Hosting Specialists
|
Edited by - Gremlin on 25 November 2003 07:18:11 |
|
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 25 November 2003 : 07:25:54
|
| Well, what I could do is make a copy of my forum and use MS SQL to compare performance, since I now have MS SQL included for no additional costs. My provider do recommend to upgrade. |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 25 November 2003 : 07:53:40
|
| Yeah go for it, not really sure how you'll "measure" the difference though, a site without much load on it could even be slower under MS SQL for the reason HuwR posted above. |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
rhagerma
Starting Member
USA
11 Posts |
Posted - 16 December 2003 : 00:55:29
|
Your more than welcome to compare your site performance with my site performance.
I am running IIS5 and SQL Server 2000 with a DSN. the pipe is redundant OC3's so network performance shouldn't be an issue and my database is about 200MB at this time.
http://www.rons-sandbox.com
Regards,
Ron hagerman |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 16 December 2003 : 07:09:56
|
quote:
Originally posted by rhagerma
Your more than welcome to compare your site performance with my site performance.
I am running IIS5 and SQL Server 2000 with a DSN. the pipe is redundant OC3's so network performance shouldn't be an issue and my database is about 200MB at this time.
http://www.rons-sandbox.com
Regards,
Ron hagerman
I would advise against using a DSN, whenever OLEDB is available, as is the case with SQL Server DBs. OLEDB is faster and more robust, and this has been verified many times in these forums. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Trina
Starting Member
31 Posts |
Posted - 18 December 2003 : 11:17:37
|
I am about to start a fresh forum (since my old one kicked the bucked and my host lost my database  ), and am thinking that I should go with SQL this time. I had, and will have again, at least a thousand users, and while I didn't ever check to see how many were on at the same time, I am sure it has been over 50 at times when there was something going on that everyone was talking about. Plus, I am going to incorporate the Classifieds and Event Calendar this time, so I expect more activity at the same time.
My question is, since I am starting out fresh, what is the best way of going about this? I am not familiar with SQL, and my host told me to just get it set up in Access, and then use the Upsizing Wizard to convert it to SQL. It seems I have read on here that isn't a good idea.
If anyone can tell me the best way to do this I would be greatly appreciative! Thanks! |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 18 December 2003 : 14:44:38
|
| Just tell your host to setup an SQL database for you and follow the instructions in the readme to set config.asp to use that database. Then run setup.asp and the database tables will be properly created for you. The advice given by the host is a complete nonsense, the forum can be setup to use SQL Server from the start and the upgrade wizard would create lots of problems. It's actually easier to setup the SQL DB from the start than using an Access setup and an upgrade from there. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
zeth
Junior Member
United Kingdom
117 Posts |
Posted - 21 December 2003 : 08:17:23
|
quote:
Originally posted by Trina
my host lost my database ),
Whatever you do, I would consider taking backups this time! Since my forum is small, I FTP a backup of my database to my hardrive every so often. However, if you are going to have a massive forum then you could burn it to CD every so often, or even get a memory stick and keep a copy on your keyring! If your forum is 'mission critical' then you should backup every working day.
Since I have backups, if something goes really wrong with my host, I can just repoint my domain name to my PWS. |
THEOLOGY.ME.UK CROSSRING.COM |
|
|
| |
Topic |
|
Topic Locked
