Differences between version 8 and predecessor to the previous major change of MySql.
Other diffs: Previous Revision, Previous Author, or view the Annotated Edit History
| Newer page: | version 8 | Last edited on Saturday, August 9, 2003 5:53:30 pm | by AlastairPorter | Revert |
| Older page: | version 1 | Last edited on Saturday, September 28, 2002 8:33:52 pm | by CraigBox | Revert |
@@ -1,11 +1,11 @@
-MySql
is a relational database
management system ([RDBMS]).
+MySQL
is a quasi-[SQL] DataBase
management system ([RDBMS]).
-It is small and fast. It lacks a lot of features that other databasen, noticably PostgreSql
, offer.
+It is small and fast for low loads
. It lacks a lot of features that other databasen, noticably [PostgreSQL]
, offer. (PostgresVsMysql)
-; __When should I use MySql
?__ : When your primary concern is the speed of your
SELECT queries. Even then PostgreSql
is getting much quicker at these.
+; __When should I use MySQL
?__ : When your primary concern is the speed of simple
SELECT queries for few concurrent users
. Even then PostgreSQL
is getting much quicker at these.
-; __When should I not use MySql
?__ : When you think "It's only going to ever be a small web site...", and there's a chance it could grow into a big one. If at any point you think you might need to change to something else, start with that other system instead.
+; __When should I not use MySQL
?__ : When you think "It's only going to ever be a small web site...", and there's a chance it could grow into a big one. If at any point you think you might need to change to something else, start with that other system instead.
; __How can I lessen the impact of having to switch later on?__ : Use [PearDB] in your PHP scripts.
-----
@@ -14,4 +14,8 @@
(The door flies open and Bill Gates of Microsoft enters, flanked by two junior cardinals. Steve Ballmer has goggles pushed over his forehead. Sam Palmisano (IBM) is just an idiot.)
Gates: NOBODY expects the [InfoWorld Article|http://infoworld.com/articles/pl/xml/02/09/23/020923pldman.xml]! The chief thing missing from MySQL is subselects...subselects and views...views and subselects.... The two things missing are views and subselects...and triggers.... The *three* things missing are views, subselects and triggers...and an almost fanatical devotion to row-level transactions.... The *four*...no... *Amongst* the things missing from MySQL ...are such elements as views, subselects.... I'll come in again. (Exit and exeunt)
+
+-----
+
+Thanks LeandroDutra for your edits, but please note that incorrect capitalisation is often the sign of a WikiWord, and shouldn't be edited. The same goes for acronyms that might not be correct but have a link attached to them - if you are going to change them, please create the new link and then link the new page to the old one for reference.
