Re: "Members site", how to set up?
Alessandro Pisa <[email protected]>
| Newsgroups | gmane.comp.web.zope.plone.user |
|---|---|
| Message-ID | <CAFLUjzMUbq7RZi6z_Mki4dVMOogAyg8wN5DbcCMSKJWrRH_iWA@mail.gmail.com> |
On 3 March 2015 at 12:01, Daniel Jowett <[email protected]> wrote: > Good to know. Out of interest, how scalable do you think Plone & > dexterity.membrane > are from your experience? > At what stage would you consider wiring in SQL for members? 10,000 users or > 100,000? > I am using membrane (AT version) in a site with 350k users. It is using a storage adapter which stores some of the at fields on postgres. I had some issues with the membrane catalog (I was wrongly adding to many ZCTextIndex). The catalog got bloated. Apart of that it is performing not bad at all, but if I would do it again I would not use this solution anymore. The experience I had let me think that: - flat data structures should go in relational DB (user data) - nested structures should go in object DB (user contents) This is why I would instead use heavily postgres to save/query user data and simply use folders for storing member contents. Ciao -- @ale_pisa - http://alepisa.blogspot.com ------------------------------------------------------------------------------ Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/