Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - SQL vs Access
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

SQL vs Access
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
velkymx View Drop Down
Groupie
Groupie


Joined: 24 February 2003
Location: United States
Status: Offline
Points: 44 		Post Options Post Options   Thanks (0) Thanks(0)   Quote velkymx Quote  Post ReplyReply Direct Link To This Post Topic: SQL vs Access
    Posted: 22 April 2003 at 12:18pm
Is SQL that much better for a large traffic messageboard? What are the benifts, is it work the extra money to run the SQL server?
Back to Top
boyohboy View Drop Down
Groupie
Groupie


Joined: 15 October 2002
Location: United States
Status: Offline
Points: 197 		Post Options Post Options   Thanks (0) Thanks(0)   Quote boyohboy Quote  Post ReplyReply Direct Link To This Post Posted: 22 April 2003 at 12:30pm

SQL Server is enterprise-level, money making stuff.

Access is more like hobby stuff.

So, the bottomline is what's your business?

 

 
Visit my community website @
EverythingVIET.com
Back to Top
Dergal View Drop Down
Groupie
Groupie


Joined: 21 January 2002
Location: United Kingdom
Status: Offline
Points: 67 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Dergal Quote  Post ReplyReply Direct Link To This Post Posted: 22 April 2003 at 12:31pm

Is SQL that much better for a large traffic messageboard?

  • Yes

Is it worth the extra Cash?

  • Depends

OK the more complicated answer is that forums are server intensive, I know a lot of companies (hosting) who passionately hate them, multiple queries running all the time, some quite complex, people writing to the system repeatedly and so on...

Access is pretty good, particularly v2000 (and above) however SQL is better... especially when WRITING / UPDATING information to the forum...  So, a popular forum - yes, an unpopular one - no!

 
Back to Top
velkymx View Drop Down
Groupie
Groupie


Joined: 24 February 2003
Location: United States
Status: Offline
Points: 44 		Post Options Post Options   Thanks (0) Thanks(0)   Quote velkymx Quote  Post ReplyReply Direct Link To This Post Posted: 22 April 2003 at 12:32pm
We currently get over 30,000 visitors a day (not hits) I just want to know if we deploy an Access version, is it going to handle the load?
Back to Top
Dergal View Drop Down
Groupie
Groupie


Joined: 21 January 2002
Location: United Kingdom
Status: Offline
Points: 67 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Dergal Quote  Post ReplyReply Direct Link To This Post Posted: 22 April 2003 at 12:34pm

Probably, most of the time, depending on the server...
if its access 2000

SQL will definently...

Back to Top
velkymx View Drop Down
Groupie
Groupie


Joined: 24 February 2003
Location: United States
Status: Offline
Points: 44 		Post Options Post Options   Thanks (0) Thanks(0)   Quote velkymx Quote  Post ReplyReply Direct Link To This Post Posted: 22 April 2003 at 12:36pm
We will be running Win2k Server w/Access 2002 or mySQL 4.0.12 - it all depends on what will work.
Back to Top
boyohboy View Drop Down
Groupie
Groupie


Joined: 15 October 2002
Location: United States
Status: Offline
Points: 197 		Post Options Post Options   Thanks (0) Thanks(0)   Quote boyohboy Quote  Post ReplyReply Direct Link To This Post Posted: 22 April 2003 at 12:39pm

Originally posted by velkymx velkymx wrote:

We currently get over 30,000 visitors a day (not hits) I just want to know if we deploy an Access version, is it going to handle the load?

I really don't think a flat file Access (any version) can handle 30,000 visitors. Man, if you got 30,000 visitors, the hits must be way way more than 30,000.

Go "evaluate" yourself how THIS wwg forum runs,which runs on sQl.

boy
Visit my community website @
EverythingVIET.com
Back to Top
velkymx View Drop Down
Groupie
Groupie


Joined: 24 February 2003
Location: United States
Status: Offline
Points: 44 		Post Options Post Options   Thanks (0) Thanks(0)   Quote velkymx Quote  Post ReplyReply Direct Link To This Post Posted: 22 April 2003 at 12:40pm
Well we are currenty running a site that is powered by Access... but we have yet to deploy a forum.
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.