Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Maximum Users
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Maximum Users

 Post Reply Post Reply Page  12>
Author
Michael Jr. View Drop Down
Newbie
Newbie


Joined: 21 May 2003
Status: Offline
Points: 11
Post Options Post Options   Thanks (0) Thanks(0)   Quote Michael Jr. Quote  Post ReplyReply Direct Link To This Post Topic: Maximum Users
    Posted: 16 June 2003 at 10:55am

This may be a stupid question, but waht is the maximum that the Access version will support?  Let's say the server is a fairly modern setup.  At what point does it start to bog down?

Thanks - Mike

Back to Top
fernan82 View Drop Down
Mod Builder Group
Mod Builder Group
Avatar

Joined: 17 November 2002
Location: United States
Status: Offline
Points: 362
Post Options Post Options   Thanks (0) Thanks(0)   Quote fernan82 Quote  Post ReplyReply Direct Link To This Post Posted: 16 June 2003 at 4:15pm
access only supports a few connections, it don't even take about 10 users browsing at the same time to slow it down.....
FeRnAN
Back to Top
rickrms View Drop Down
Newbie
Newbie


Joined: 13 June 2003
Status: Offline
Points: 9
Post Options Post Options   Thanks (0) Thanks(0)   Quote rickrms Quote  Post ReplyReply Direct Link To This Post Posted: 16 June 2003 at 5:25pm

Is it easy to setup the SQL dB Version of this forum? Does the program setup the tables itself? Or do I need to know sql really well to pull it off?  And how many users can that handle?

 

Thanks

Rick

Back to Top
fernan82 View Drop Down
Mod Builder Group
Mod Builder Group
Avatar

Joined: 17 November 2002
Location: United States
Status: Offline
Points: 362
Post Options Post Options   Thanks (0) Thanks(0)   Quote fernan82 Quote  Post ReplyReply Direct Link To This Post Posted: 16 June 2003 at 5:40pm
ms sql doesn't have a connection limit, and yes there's a file that comes with the sql version that will setup the db for you.
FeRnAN
Back to Top
rickrms View Drop Down
Newbie
Newbie


Joined: 13 June 2003
Status: Offline
Points: 9
Post Options Post Options   Thanks (0) Thanks(0)   Quote rickrms Quote  Post ReplyReply Direct Link To This Post Posted: 16 June 2003 at 5:59pm

Thank you for your reply.  I have another question. Does anyone else have this problem I’m about to explain.  It seams that when ever I come onto this message board after about 5 minutes or less my system starts to slow down and my mouse and keyboard go into like a delayed mode.  Almost like I remember some of my old systems when I would go on the net and I had to empty my cache mem.  Real strange.  Then I end up having to reboot and it’s ok.

Thank you.

Back to Top
fastfred View Drop Down
Groupie
Groupie


Joined: 10 December 2002
Location: Netherlands
Status: Offline
Points: 78
Post Options Post Options   Thanks (0) Thanks(0)   Quote fastfred Quote  Post ReplyReply Direct Link To This Post Posted: 17 June 2003 at 1:00am
My forum  (http://www.mtb-sport.nl/forum/ ) uses msAcces and no problems with 25 people at the same time browsing the forum.
   
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: 17 June 2003 at 2:45am

Access can handle 255 connections, but on the web this is increased further as IIS pools the connection.

When a page loads it take only 0.01 of a secound to process as soon as this is done the database connection is dropped anyway, so it isn't really that much of an issue.

The problem with Access is more to do with it being a flate file, so the larger is grows the larger the file that needs to be loaded into memory each time, thuse slowing down the forum, so you need to keep the database size down.

Back to Top
Michael Jr. View Drop Down
Newbie
Newbie


Joined: 21 May 2003
Status: Offline
Points: 11
Post Options Post Options   Thanks (0) Thanks(0)   Quote Michael Jr. Quote  Post ReplyReply Direct Link To This Post Posted: 18 June 2003 at 12:47pm

If my forum is running on the access version, how hard would it be to convert to the sql?  Or would I need to start from scratch?

At what point do you know that the Db has reached capacity?

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.