Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS Access
 can access support 1000 users at the same time?
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

tianzhuy
Starting Member

6 Posts

Posted - 25 May 2001 :  03:47:14  Show Profile
I installed the forum with access database,I want a lot of users(such as 1000 ) to post at the same time to discuss something. I don`t know whether the forum support it.
( I don`t have the sql.)


Azaniah
Senior Member

United Kingdom
1004 Posts

Posted - 25 May 2001 :  06:00:43  Show Profile  Visit Azaniah's Homepage
I'm no expert but I seriously doubt it.
1000 concurrent users is a HUGE amount, you will need something more powerful than Access to run that kind of database. Let alone the server to run that beasty on.

Cheers Az




-------
Eagles fly!, but weasels don't get sucked into jet engines.
Go to Top of Page

tilttek
Junior Member

Canada
333 Posts

Posted - 25 May 2001 :  08:20:07  Show Profile  Visit tilttek's Homepage
quote:

I'm no expert but I seriously doubt it.
1000 concurrent users is a HUGE amount, you will need something more powerful than Access to run that kind of database. Let alone the server to run that beasty on.



More that 30 you are killing yourself.

And 1000 Concurent users is VERY big... 200 is for very very good board.



Philippe Gamache
http://www.tilttek.com
http://www.lapageamelkor.com
Go to Top of Page

tianzhuy
Starting Member

6 Posts

Posted - 25 May 2001 :  08:37:35  Show Profile
well,now I know my plan is impossible!
because I only have SQL server 6.5,but it doesn`t support chinese , I changed to use access.
thanks a lot for your help



Edited by - tianzhuy on 25 May 2001 08:39:18
Go to Top of Page

davemaxwell
Access 2000 Support Moderator

USA
3020 Posts

Posted - 25 May 2001 :  08:41:19  Show Profile  Visit davemaxwell's Homepage  Send davemaxwell an AOL message  Send davemaxwell an ICQ Message  Send davemaxwell a Yahoo! Message
quote:

I installed the forum with access database,I want a lot of users(such as 1000 ) to post at the same time to discuss something. I don`t know whether the forum support it.
( I don`t have the sql.)



Having 1000 users hitting the database at EXACTLY the same time would be very nearly impossible (notice I did say nearly). You would have to have 1000 users who start up the forum at exactly the same moment to all hit the database at the same time.

Access 97 does not handle as many concurrent users as 2000, but if you've got SQL Server 6.5, why aren't you using that? Snitz should be able to work with 6.5 since I don't think there is THAT much difference between 6.5 and 7, which this site is running on...

Dave Maxwell
--------------
Proud to be a "World Class" Knucklehead
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts

Posted - 25 May 2001 :  23:04:19  Show Profile
quote:
Access 97 does not handle as many concurrent users as 2000, but if you've got SQL Server 6.5, why aren't you using that? Snitz should be able to work with 6.5 since I don't think there is THAT much difference between 6.5 and 7, which this site is running on...

6.5 doesn't support Unicode like 7+ does, which presents big problems for foreign language sites.

Access has a maximum connection count of 250.



======
Doug G
======
Go to Top of Page

@tomic
Senior Member

USA
1790 Posts

Posted - 31 May 2001 :  16:39:55  Show Profile  Visit @tomic's Homepage  Send @tomic an ICQ Message
If you plan on using Access, you should check out this article:

http://www.15seconds.com/Issue/010514.htm

Many questions about the scalability of Access are answered there.

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.23 seconds. Powered By: Snitz Forums 2000 Version 3.4.07