Thanks for your response, if anyone have another experience with big databases this could be usefull for me and certainly for other people.
Le mercredi 25 juin 2014 22:03:21 UTC+2, Holtkamp a écrit : > > 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] <javascript:> > > 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] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> 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.
