Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    Regular Coder
    Join Date
    Jul 2002
    Location
    Brighton, UK
    Posts
    282
    Thanks
    1
    Thanked 0 Times in 0 Posts

    is ASP old hat, especially with access data

    hello.. not a coding problem but an interesting question..

    for me I enjoy using ASP and linking to ACCESS.. its easy and simple.. but recently I have been designing and coding for larger companies.. I am just about to create a site but that gets over 5000 clicks aday..

    is it a wise idea to design and construct a site with high traffic in ASP using ACCESS ??

    I have used .NET but i find it too corporate and i love ASP for its fexibility,, i think if i do expand PHP would be my choice ??

    your input on this would be great ...
    <marquee>thanks</marquee>

  • #2
    Regular Coder
    Join Date
    Jan 2005
    Posts
    155
    Thanks
    0
    Thanked 0 Times in 0 Posts
    if you're expecting that high number of visitors and you will be accessing data from a database, you would be wise not to use Access and look at either MSSQL or MySQL. Although .NET is the up and coming thing there is nothing saying that you can't develop the site in ASP. Your concern is really only the database being used.

  • #3
    Senior Coder
    Join Date
    Dec 2002
    Location
    Arlington, Texas USA
    Posts
    1,062
    Thanks
    4
    Thanked 8 Times in 8 Posts
    Using Access on a site that gets a large volume of hits is definately not the way to go. One of Access' limitations is the number of concurrent connections. Access has a limit of 7 concurrent connections. So while it is possible that with 5000 hits a day that most people will have no problem, the user who happens to make a request at the exact same time as 7 other people do could be shown an error. Definately pick a more robust database.

    Depending on who does the hosting MySQL may be available and if so it is a much better option than Access. However many webhosts don't have MySQL on their windows machies but do have MS SQL Server.


    Plus MySQL and SQL Server offer advantages like stored procedures, and user defined functions that are not found in Access.

  • #4
    Senior Coder Spudhead's Avatar
    Join Date
    Jun 2002
    Location
    London, UK
    Posts
    1,856
    Thanks
    8
    Thanked 110 Times in 109 Posts
    Quote Originally Posted by miranda View Post
    Access has a limit of 7 concurrent connections
    I've heard a lot of numbers for how many Access supports. Usually between 12-15. But I've never seen anything that looks official, and I've never heard 7. I'm not doubting you - I agree entirely that it'll fall over if you try to run anything... "commercial" scale... but if you could point me at something that I could use when trying to talk people out of running sites off Access, I'd be very grateful


  •  

    Posting Permissions

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