I'm using MySql with Doctrine 2 and as I understand it, Doctrine 2 has to use the InnoDB storage engine to create foreign keys. But InnoDB has a limit of 1000 columns. I've got one table that is approaching that limit. Naturally, I'm considering some options for redesigning the database to avoid this problem, but I'm not seeing any great options. Before I make major changes to my code, I wanted to confirm my suspicion that there's really no way to have an entity with more than 1000 columns while still making use of foreign keys (which are not supported by MyISAM).
-- You received this message because you are subscribed to the Google Groups "doctrine-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/doctrine-user. For more options, visit https://groups.google.com/d/optout.
