ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Is EE able to handle big data / big sites?

January 08, 2009 4:52pm

Subscribe [8]
  • #16 / Jan 12, 2009 12:19pm

    Pete Smith

    91 posts

    Helmi;

    Related fields can be problematic in bigger sites because of the way EE handles them. They can bloat the database pretty quickly. In our case, we had a weblog called Companies and another called Products. We had about 80,000 entries in the Product weblog and a relational field to pull in Company data. The exp_relationships table got *huge* from that since it caches both related data and reverse_related data in the table.

    It’s pretty easy to work around this limitation by just using sql queries instead of relationship fields.

    We host a few online publications at EngineHosting.com using EE and aside from that snafu with relationship fields (and they work fine for more modest purposes) we’ve been very pleased with the results. We do 1-1.5 million page views/month on our busiest site, if that helps you judge. Now that site only has about 4,000 entries, though.

  • #17 / Jan 12, 2009 4:19pm

    LynneL

    239 posts

    Whoa, Mark, thanks for that find. I really ought to just go to Solspace and spend an hour reading up on every one of their additions to EE. Yeesh! Every time I think I have an insurmountable problem it seems Solspace beat me to a solution. 😊

  • #18 / Jan 13, 2009 6:05am

    Mark Bowen

    12637 posts

    Yep they have saved my bacon quite a few times now. Their modules really are fantastic and the crew over there are equally great.

    Best wishes,

    Mark

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases