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 10 of 10
  1. #1
    Regular Coder
    Join Date
    Oct 2006
    Location
    Spain
    Posts
    147
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Cool Limit of MS Access

    Hi,

    Certainly this forum discuss ASP, however do you use a database together the ASP scripts?

    I would like hearing from yours the limit in mb or records can have a MS Access database - no lost its performance.

    5mb? 10mb? 50mb? more?

    I am trying use large MS Access databases online.

    Thank you.

    Lebron

  • #2
    Regular Coder westmatrix99's Avatar
    Join Date
    Dec 2006
    Location
    South Africa
    Posts
    307
    Thanks
    12
    Thanked 0 Times in 0 Posts
    The biggest Access database I have ever worked on became just over 1GB offline in a Visual Basic app I created.

    Online? I wouldn't take a chance on "big in size" database, Access is not the best at that, well in my years of working with them they haven't performed well unless they stayed under the 10MB mark!

    I would suggest if I may that you use MS SQL or even PHP and MySQL.

    Haven't done any benchmark tests on an Access database as my "code was right", that is the biggest part when working with databases;
    Access, MS SQL or even MySQL your coding has to be right.

    Hope the helps you.
    Cheers
    Thanks for you support!

  • #3
    Senior Coder JamieR's Avatar
    Join Date
    Oct 2004
    Location
    United Kingdom
    Posts
    3,161
    Thanks
    0
    Thanked 5 Times in 5 Posts
    If you're working with large Access databases online, then I'd suggest that you migrate them over to SQL Server, if you can.

  • #4
    Regular Coder
    Join Date
    Oct 2006
    Location
    Spain
    Posts
    147
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Hi friends,

    I know the best solution in database for Win is MS SQL,but the major part of Hosting companies give a short disk space for it.

    For example, the godaddy.com have an affordable Win Plan - 100gb of disk space,bas only 200mb for MSSQL, however it costs only 6,30 USD.

    Thanks

    Lebron Letchev

  • #5
    Super Moderator
    Join Date
    May 2002
    Location
    Perth Australia
    Posts
    4,084
    Thanks
    11
    Thanked 100 Times in 98 Posts
    the biggest issue with MS ccess databases is concurrent connections, e.g. more than 4 or 5 users and it will start to slow down... quickly, & not much more until it falls over, its probably the worst multi-user option there is.
    resistance is...

    MVC is the current buzz in web application architectures. It comes from event-driven desktop application design and doesn't fit into web application design very well. But luckily nobody really knows what MVC means, so we can call our presentation layer separation mechanism MVC and move on. (Rasmus Lerdorf)

  • #6
    Regular Coder westmatrix99's Avatar
    Join Date
    Dec 2006
    Location
    South Africa
    Posts
    307
    Thanks
    12
    Thanked 0 Times in 0 Posts
    I would have to say that what you are saysing is incorrect - even though I didn't do any benchmark tests, I do remember that I had about 500 users a day accessing a website that was developed for Medical people, ontop of that I developed a database in Access for the Art awards in SA and we had about 3000 hits a day.

    I am sure that, actually I know that Access can only really handle about 20 concurrent connections "by book terms", then you will see a tiny change in speed.

    Remember it is your coding that is the speed changer!
    Last edited by westmatrix99; 06-08-2007 at 07:12 AM.
    Thanks for you support!

  • #7
    Super Moderator
    Join Date
    May 2002
    Location
    Perth Australia
    Posts
    4,084
    Thanks
    11
    Thanked 100 Times in 98 Posts
    I appreciate your experience, I can only go by mine, perhaps for simple selects and nothing else you may get 20 concurrent users but any time you try to do writes you start (in my experience) to suffer as soon as you have more than 2 or 3 concurrent users.

    I also noticed times when even though the system stayed alive data was corrupt in that referential integrity was sometimes ignored in multi-user situations, I did not try that hard to fix it since the alternatives are many and reliable.
    resistance is...

    MVC is the current buzz in web application architectures. It comes from event-driven desktop application design and doesn't fit into web application design very well. But luckily nobody really knows what MVC means, so we can call our presentation layer separation mechanism MVC and move on. (Rasmus Lerdorf)

  • #8
    Regular Coder westmatrix99's Avatar
    Join Date
    Dec 2006
    Location
    South Africa
    Posts
    307
    Thanks
    12
    Thanked 0 Times in 0 Posts
    Fair enough, I guess it just depends on the way it is coded or written.

    The objective behind coding properly is all to do with selecting the right data from the database, something I have had issues with in PHP as it is not my flavour as I coded for 8 years in ASP.

    What do I mean?
    If you only need the ID then select just the ID not the entire table and so on...
    Cheers
    Thanks for you support!

  • #9
    Super Moderator
    Join Date
    May 2002
    Location
    Perth Australia
    Posts
    4,084
    Thanks
    11
    Thanked 100 Times in 98 Posts
    I agree with you in that bad database design and poorly written SQL will slow & can eventually kill any DB.

    The point is that mssql/MySQL.PostgreSQL/firebird/etc etc will handle far more concurrent users before it falls over regardless of the quality of the database deign.

    Access I can't see getting even near the above even with optimized db and sql, its a great tool for many projects but again IME does not handle concurrency very well, even in small networks.
    resistance is...

    MVC is the current buzz in web application architectures. It comes from event-driven desktop application design and doesn't fit into web application design very well. But luckily nobody really knows what MVC means, so we can call our presentation layer separation mechanism MVC and move on. (Rasmus Lerdorf)

  • #10
    Regular Coder
    Join Date
    Oct 2006
    Location
    Spain
    Posts
    147
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Hi

    I have also a website using MAAccess. My database have near 3mb and my website receives 400-700 visits per day. I don´t know if the access is fast or slow, but I am working with this database since 2001.
    www.dictionarium.com

    The best MS SQL disk space hosting is lunarpages.com - unlimited disk space -.

    Thanks

    LeBRON Letchev


  •  

    Posting Permissions

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