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

  New Posts New Posts RSS Feed - Acess Vs SQL
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Acess Vs SQL
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
mbd2 View Drop Down
Groupie
Groupie


Joined: 21 May 2003
Location: United States
Status: Offline
Points: 124 		Post Options Post Options   Thanks (0) Thanks(0)   Quote mbd2 Quote  Post ReplyReply Direct Link To This Post Topic: Acess Vs SQL
    Posted: 08 April 2009 at 4:13pm
Over the past few months I been getting ready to convert wwf an SQL forum and been doing some simple testing.  One thing I've noticed in the Access version is running faster?  Should that be?  I thought the SQL would be faster?

Has anybody else see this, or I'm I the lucky guy with a fast running Access db.

Access Stats are:
Our users have posted 30,330 Posts in 2,744 Topics in 52 Forum(s)

Then SQL is a back of the forum and is older so in theory has less data.

Just looking for some input and ideas if the change over is worth it?
Back to Top
123Simples View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192 		Post Options Post Options   Thanks (0) Thanks(0)   Quote 123Simples Quote  Post ReplyReply Direct Link To This Post Posted: 08 April 2009 at 4:45pm
Read this web wiz information

Quote This is the slowest version of Web Wiz Forums. Access is a desktop database and is often unable to cope in a production environment leading to database corruption issues. This version should only be used for testing purposes


and then you may feel that upgrading is the better choice. However, and I always say this, make backups first

So many people run the upgrades without backing up things first, and then can end up pretty disappointed if it goes wrong
Visit 123 Simples Web Design
Back to Top
mbd2 View Drop Down
Groupie
Groupie


Joined: 21 May 2003
Location: United States
Status: Offline
Points: 124 		Post Options Post Options   Thanks (0) Thanks(0)   Quote mbd2 Quote  Post ReplyReply Direct Link To This Post Posted: 08 April 2009 at 5:11pm
That statement was not always there.  When I started with version 5 (I think) it was just an option.  Just recently  did I notice the statement saying it should be used for testing only.

I always backup the db and the forum - just encase I have to revert back to the old format.  Never really had to do that, but just a precaution I take just encase hard ware and software are not compatible.
Balloon Entertainment at it's best! www.mbd2.com -- Trade Show Presenter - video
Back to Top
Lynford View Drop Down
Groupie
Groupie


Joined: 14 December 2004
Status: Offline
Points: 171 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Lynford Quote  Post ReplyReply Direct Link To This Post Posted: 08 April 2009 at 5:24pm
I don't understand the technicalities of Access Vs SQL but I can share this with you:

I was running on Access, was having a lot of trouble with my Web Hosts, had to clean up the Database regularly by deleting posts, Forum was running very slowly, sometimes almost grinding to a standstill etc etc.

I now host with WebWiz (which may be a big difference as well) but we are running SQL. It is brilliant - Has been like this since early February and not one problem (touch wood)

I know Bruce & WebWiz can't recommend SQL over Access strongly enough.

Our users have posted 109,302 Posts in 6,986 Topics in 10 Forum(s)

Regularly have 200-300 Users online.

Hope this helps Big smile
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 09 April 2009 at 10:02am
There are lots of issues with Access here are just a few:-

  • Access is a desktop database and was only made available for web use as Microsoft's SQL Server at the time was to expensive
  • Access has a limitation of 250 simultaneous connections shared with all websites and databases on the same server (this is theoretical in practice it is lower)
  • Access uses a flat file stored on the web server. The web server usually has a disk system that is intended for fast reads and not for databases. SQL Server is usually placed on a dedicated database server with a disk system that can handle fast sequential reads and writes
  • Access is fine for small databases under 10MB in web use or infrequently accessed databases, but often becomes corrupted when under load. Forums place a large load on the database so Access is not very good
  • Now Microsoft have the free SQL Server Express and the Web Edition they are phasing out support in their new OS's for Access. They have said they will not make a 64 bit JET driver
  • Access doesn't have the same server side paging as you would get from SQL Server
If you use the Access version of SQL Server it has been altered to place less load on the server due to limitations with Access. For example your forums will only display the first 1,000 topics, instead of all topics that you have with SQL Server with the server side paging.

We also see lots of issues with Access databases especially as forums get larger and busier and could only recommend that you use the Access version of Web Wiz Forums if you expect only a handful of visitors each day.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
 Post Reply Post Reply

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.