From: | Maximilian Tyrtania <maximilian(dot)tyrtania(at)onlinehome(dot)de> |
---|---|
To: | <briefkasten(at)olaf-radicke(dot)de>, postgres-liste <pgsql-de-allgemein(at)postgresql(dot)org> |
Subject: | Re: Fremdschl=?ISO-8859-1?B?/A==?=sseln Limit |
Date: | 2008-12-12 13:57:01 |
Message-ID: | C5682C3D.31B2D%maximilian.tyrtania@onlinehome.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-de-allgemein |
Hi,
> Frage: Der SQL-Server von Microsoft hat bei Fremdschlüsseln ein Limit von 32.
Sicher? Hab "sql server foreign keys limit" gegoogelt und das hier gefunden:
(http://msdn.microsoft.com/en-us/library/ms175464.aspx)
SQL Server does not have a predefined limit on either the number of FOREIGN
KEY constraints a table can contain (which reference other tables), or the
number of FOREIGN KEY constraints owned by other tables that reference a
specific table. Nevertheless, the actual number of FOREIGN KEY constraints
is limited by your hardware configuration and by the design of your database
and application. We recommend that a table contain no more than 253 FOREIGN
KEY constraints, and that it be referenced by no more than 253 FOREIGN KEY
constraints. Consider the cost of enforcing FOREIGN KEY constraints when you
design your database and applications.
> Hat PostgreSQL ein Limit?
Davon hätte ich wahrscheinlich gehört...
Maximilian Tyrtania | IT-Entwickler
Mty(at)fischerAppelt(dot)de
fischerAppelt Kommunikation GmbH
Friedichstr. 149 | D-10117 Berlin | Germany
Tel. ++49-30-726146-728 | Fax ++49-30-726146-710
www.fischerAppelt.de
---------------------------------------------------------------------------
Sitz der Gesellschaft: Hamburg
Standorte: Hamburg, Berlin, Düsseldorf, Frankfurt, München, Stuttgart
Die Gesellschaft ist Teil des Everpublic Networks
Handelsregister: Amtsgericht Hamburg, HRB 49259
Geschäftsführer: Andreas Fischer-Appelt, Bernhard Fischer-Appelt
+++ fischerAppelt macht Fernsehen: www.fischerappelt-tvmedia.com +++
From | Date | Subject | |
---|---|---|---|
Next Message | Olaf Radicke | 2008-12-12 14:37:03 | Re: Fremdschlüsseln Limit |
Previous Message | A. Kretschmer | 2008-12-12 13:48:32 | Re: Fremdschlüsseln Limit |