Results 1 to 8 of 8

Thread: Database Size

  1. #1
    Join Date
    Apr 2004
    Posts
    3

    Unanswered: Database Size

    I have a little over 1300 products in my database at this time. I have read posts from other ASP database owners stating that their database is "overloaded" and therefore is running very slow. Does anyone know the approximate max. size that an ASP database can be without getting overloaded? Thx!

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    108

    Post ...

    Call me crazy, but I have never heard of an "ASP DATABASE". Do you mean Sql Server, Access, MySql, or something else? If so, you shoud post this qeustion on those forums.

    This is for ASP, a programming scripting language. I am sorry if I am a little harsh, but I see alot of non-ASP questions on this forum.

    ~Le

  3. #3
    Join Date
    Apr 2004
    Posts
    3
    I'm sorry, I should have been more clear. It is an Access database (uses active server pages). I will find the correct forum for this. Thx

  4. #4
    Join Date
    Apr 2004
    Posts
    50
    Originally posted by 1234
    I'm sorry, I should have been more clear. It is an Access database (uses active server pages). I will find the correct forum for this. Thx
    Hi,

    You'll be fine with Access database having 1300 products, if there aren't too many concurrent users connecting to it.

  5. #5
    Join Date
    Apr 2004
    Posts
    3

    Wink

    Thanks very much! I'm about to add a few hundred more, just wanted to make sure it wasn't going to overload it.

  6. #6
    Join Date
    Apr 2004
    Posts
    50
    If you start getting many concurrent users then you can easily upsize it to SQL Server database

  7. #7
    Join Date
    Apr 2004
    Posts
    1
    my hosting supports

    MySQL (Windows)
    MS Access (Windows)

    does this mean that it is sql server?

    is Mysql for windows is Sql server?

    can someone just give me a little assistance in defining what is and the difference between

    -ms Access DB with and without dsn connection
    - MySQL Windows

    im looking at getting a client portal created (with many users) that needs to be fast and reliable, not crash etc. Given my hosting support, what would be the best option for me

    thanks heaps for helping me out on this one

  8. #8
    Join Date
    Apr 2004
    Posts
    50
    Oscillate,

    MS SQL Server 2000 is an enterprise database, which is suitable for websites with high traffic requirements and for transactional Ecommerce websites as well.

    MySQL is an open source database (it has versions for both Linux and Windows) and it's not the same thing like MS SQL Server 2000. MS SQL Server 2000 is much better option as a database solution.

    MS Access should be your last choice for a web database, as it's designed primary as a desktop databasea dn can't handle many concurrent users.

    I would recommend to use SQL Server 2000 for your portal if you're expect to have many concurrent users and if you expect top performance and reliability.

    I hope this helps.

Posting Permissions

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