Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more - View Single Post

bobena · 10-27-2008, 04:51 PM

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 money wasn't an issue - unlimited funding? Would it change your answer?

10-27-2008, 04:51 PM	#1 (permalink)
bobena Junior Member Join Date: Oct 2008 Posts: 1	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 money wasn't an issue - unlimited funding? Would it change your answer?