SitePoint Sponsor

User Tag List

Results 1 to 7 of 7
  1. #1
    SitePoint Enthusiast joe1275's Avatar
    Join Date
    Aug 1999
    Posts
    45
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    ASP scalability???

    Is there a limit of simultaneous users that a ASP code can handle? For example, My programmer developed a tool that a person can use online to find out how many calories he burned that day. This tools is splited in 6 parts/pages.
    1-Introduction; 2-chosing activities at home; 3-chosing sports activities; 4-choosing fitness activities; 5-typing weight and minutes of each activity selected; 6-displaying results. This tools uses ASP accessing SQL.

    Is there such a thing as ASP scalability to allow more users at the same time using the tool or it is only a matter of hardware?

    Thanks
    Joe

  2. #2
    SitePoint Wizard big_al's Avatar
    Join Date
    May 2000
    Location
    Victoria, Australia
    Posts
    1,661
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    ASP is parsed by the server so, yes it is a Hardware issue, MS SQL can handle ALOT!
    The better your code is written and optimized the better the performance of the server.

    Sloppy code and crash your server
    .NET Code Monkey

  3. #3
    SitePoint Wizard silver trophy Jeremy W.'s Avatar
    Join Date
    Jun 2001
    Location
    Toronto, Canada
    Posts
    9,123
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    depending on your database engine, your hardware, your connection and your webserver (too many requests to the server object will crash any server).

    But, put it this way. Access 2000 running on a P2 300 with an ISDN connection can handle 250 SIMULTANEOUS users without too much of a problem.
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  4. #4
    SitePoint Enthusiast Vpekulas's Avatar
    Join Date
    Mar 2000
    Location
    Winnipeg, Canada
    Posts
    68
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by studiococo
    But, put it this way. Access 2000 running on a P2 300 with an ISDN connection can handle 250 SIMULTANEOUS users without too much of a problem. [/B]
    Where did you hear that ? As far as I know Access 2k will have problems with as little as 100 concurent connections.

    There isn't too much information on the net regarding this issue though
    Vladimir S. Pekulas
    http://www.Europeum.net
    http://wap.Europeum.net

  5. #5
    SitePoint Wizard big_al's Avatar
    Join Date
    May 2000
    Location
    Victoria, Australia
    Posts
    1,661
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Maybe access can handle it, but I would hate to see the speed of it.

    If you can afford it go for MS SQL
    .NET Code Monkey

  6. #6
    SitePoint Wizard westmich's Avatar
    Join Date
    Mar 2000
    Location
    Muskegon, MI
    Posts
    2,328
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    To contradict an earlier statements I made around here, Access 2000 begins to have problems with more then 25 connections.

    Keep in mind that if your coding correctly, (open connection, open recordset, manipulate, close and destroy connection and recordset) connections last from less then a second to 2 or 3 seconds. You may have a thousand users on your site with no problems because there are only a few simaltanious users making db connections at any one time.

    Also keep in mind that Access is a file, MySQL, SQL Server, Oracle, etc... are database servers.
    Westmich
    Smart Web Solutions for Smart Clients
    http://www.mindscapecreative.com

  7. #7
    SitePoint Enthusiast Vpekulas's Avatar
    Join Date
    Mar 2000
    Location
    Winnipeg, Canada
    Posts
    68
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    But then again, Access is probably a good way to start with DB's and cost effective, copmared to SQL etc.
    Vladimir S. Pekulas
    http://www.Europeum.net
    http://wap.Europeum.net


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •