Results 1 to 2 of 2

Thread: Questions when choosing a DBMS

  1. #1
    johnting101 is offline Newbie Net Builder
    Join Date
    Jun 2009
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Questions when choosing a DBMS

    Which database is the most scalable – MySQL, SQL, Oracle, something else?
    Which of the above can handle the most queries quickly and efficiently?
    Does the programming language affect the speed of the query? If so, what is the fastest?
    Is there a size limit to a single database on any of the database management systems? (MySQL, SQL, Oracle, etc?)
    If you were designing a website with millions of database records, queries, and page views per day, what would you choose? What if cash
    was not an issue - unlimited funding? Would your answer change?

  2. #2
    moonpeach is offline Newbie Net Builder
    Join Date
    Jul 2009
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Probably Oracle, with SQL Server as a close #2, and MySQL as a distant #5. PostgreSQL, SQL Lite, and others come in between.



    It depends somewhat on the specific queries and data, of course. But again, it's Oracle and SQL Server.



    Absolutely! Good coding is essential. In any language.



    Yes. Thousands of terabytes. In most real world scenarios you'll be limited by the amount of cash
    you'll spend on drives and on architecture, rather than by the amount of storage a computer can address.



    I would choose SQL Server (2008, Enterprise Edition) because it's among the best, and, more importantly, because I have the most detailed knowledge of it, allowing me to build out competent architecture to support whatever I was trying to do.

    Now some questions

    1. Are you building a transactional, or reporting system?
    2. How is your data structured?
    3. What types of queries will be asked, by how many people, at any given time?
    The code you put into the database (ie, what you ask it to do) is far more important than whether you choose SQL Server or Oracle. Both are up to the job of running good code against hundreds of millions of rows. Both will easily choke on bad code with very small data sets. Unless you know the difference between an index scan and a bookmark lookup, it won't matter which RDBMS you choose.

Similar Threads

  1. Choosing the Right Forum for a Banner Ad
    By garfish in forum Announcements and Suggestions
    Replies: 2
    Last Post: 13 January, 2010, 12:46 PM
  2. Choosing a Topic for Your Web Site
    By Will.Spencer in forum Building
    Replies: 11
    Last Post: 5 December, 2009, 16:23 PM
  3. Choosing the Right software
    By Coastercraze in forum Community Building
    Replies: 9
    Last Post: 14 May, 2009, 08:40 AM
  4. Choosing a Programming Language
    By Karl in forum Managing
    Replies: 0
    Last Post: 9 April, 2009, 11:58 AM

Tags for this Thread

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
  •