Differences between version 11 and previous revision of MySQL.
Other diffs: Previous Major Revision, Previous Author, or view the Annotated Edit History
| Newer page: | version 11 | Last edited on Saturday, September 18, 2004 9:28:18 pm | by JohnMcPherson | Revert |
| Older page: | version 10 | Last edited on Thursday, June 17, 2004 5:13:26 pm | by AristotlePagaltzis | Revert |
@@ -1,7 +1,7 @@
[MySQL] is a [Relational|RelationalDataBase]/[PostRelational|PostRelationalDataBase] DataBase management system. It is the canonical example of a successful commercial OpenSource product. This has been attributed primarily to the fact that it's DualLicensed.
-Some also say it is devil spawn or a horrible piece of badly written software. It's very fast at low loads because it's hardly more than a glorified flat file database with an [SQL] interface, but that comes at the expense of any feature anyone would find useful ([TransAction]s
, as one example). It sucks at large joins and has trouble handling tables with a few million rows in them.
+Some also say it is devil spawn or a horrible piece of badly written software. It's very fast at low loads because it's hardly more than a glorified flat file database with an [SQL] interface, but that comes at the expense of any feature anyone would find useful (Transactions
, as one example). It sucks at large joins and has trouble handling tables with a few million rows in them.
;: ''Loud jarring chord!''
;: ''The door flies open and BillGates of [Microsoft] enters, flanked by two junior cardinals. Steve Ballmer has goggles pushed over his forehead. Sam Palmisano ([IBM]) is just an idiot.''
@@ -12,10 +12,12 @@
If you want a relational [DataBase], use [PostgreSQL]. You'll love yourself forever if you do. See PostgresVsMysql.
; __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.
-; __How can I lessen the impact of having to switch later on?__ : Use PearDB in your PHP scripts.
+
+
; __How can I lessen the impact of having to switch later on?__ : Use PearDB in your [
PHP] scripts, or DBI in your [Perl]
scripts.
!!! WARNING
* DO NOT USE MYSQL'S RAND() FUNCTION, IT CAUSES YOUR DATABASE TO DISAPPEAR
