Changes between Version 24 and Version 25 of ModelInheritance


Ignore:
Timestamp:
03/19/2006 10:19:55 PM (9 years ago)
Author:
Andy Dustman <farcepest@…>
Comment:

Info on MySQL compatibility

Legend:

Unmodified
Added
Removed
Modified
  • ModelInheritance

    v24 v25  
    5151CREATE TABLE "myapp_restaurant" (
    5252    /* PRIMARY KEY REFERENCES "myapp_places" ("id") works for postgres, what about others? */
     53    /* This works in MySQL too. -- Andy Dustman */
    5354    "id" integer NOT NULL PRIMARY KEY REFERENCES "myapp_places" ("id"),
    5455    "description" text NOT NULL
     
    9899''
    99100I 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
     101''
     102
     103''
     104MySQL-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
     105older. -- Andy Dustman
    100106''
    101107
Back to Top