For an e-commerce project we have now 222 Entities defined, which involve 185 tables on MySQL. We have had no performance issues so far. Indeed metadata caching is important to have, we use a two-level cache approach, using APC as fast (though volatile) cache and MongoDB as slow (though persistent) cache. This way we can spin up new server instances quickly when required.
But I do think that when your amount of Entities 'keeps' growing, you should reconsider your model. Each domain has a certain limit, taking proper normalization and abstractions into account. Our amount of Entities is now stable for around a year. Concerning the amount of entries in your database, carefully think about your associations and avoid bi-directional ones where possible. This is also stressed here: http://docs.doctrine-project.org/en/latest/reference/best-practices.html Good luck! On 25 June 2014 21:43, Nicolas de Marqué <[email protected]> wrote: > Hello, > > I used doctrine for many projets (often with symfony and in this > particuliar case too). > > My experiment doesn't include large database (not for data quantities bu > for structure more than 100 tables i think). > > So as i should work on project which begin with 10/30 tables but should > extends to 50 to 500 tables, i demand me if doctrine has a limit. As > doctrine use a centralisation process with all metadata cached and loaded > for each request, the system should have a limit in complexity to be > efficient. > > Have you informations about large database with many entities? > > Does it exist a limit to the table quantity? > > > - more than 50, 100, 500, 1000, + ? > > Have you any experience with such databases? > > Best Regards, > > Nicolas de Marqué > > -- > 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 http://groups.google.com/group/doctrine-user. > For more options, visit https://groups.google.com/d/optout. > -- 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 http://groups.google.com/group/doctrine-user. For more options, visit https://groups.google.com/d/optout.
