Changes between Version 24 and Version 25 of ModelInheritance

Timestamp:

Mar 19, 2006, 10:19:55 PM (19 years ago)

Author:

Andy Dustman <farcepest@…>

Comment:

Info on MySQL compatibility

ModelInheritance

@@ -51 +51 @@
 CREATE TABLE "myapp_restaurant" (
     /* PRIMARY KEY REFERENCES "myapp_places" ("id") works for postgres, what about others? */
+    /* This works in MySQL too. -- Andy Dustman */
     "id" integer NOT NULL PRIMARY KEY REFERENCES "myapp_places" ("id"), 
     "description" text NOT NULL
@@ -98 +99 @@
 ''
 I think some dbs have a maximum number of joins (something like 16), and even within the maximum, the query optimizer will either spend a while deciding which way to best join the tables or it will give up and choose the wrong way quickly.  This wording is FUD-- I'll try to find specifics.  --jdunck
+''
+
+''
+MySQL-4.1 and newer can handle up to 61 tables in a JOIN or VIEW (5.0 and newer). Unclear what the limit is for 4.0 and
+older. -- Andy Dustman
 ''