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.

Tabular Data Best Practices

December 17, 2007 10:48am

Subscribe [0]
  • #16 / Dec 18, 2007 2:23pm

    Pete Smith

    91 posts

    I may just build the entire thing outside of EE and then get some pro help in making the EE login and cookies work with it.

    Check out CodeIgniter. It’s a PHP framework from the same folks that brought you EE, and there’re a few simple, pretty nice authentication modules for it.

    And though I haven’t looked into this, I wouldn’t be surprised if someone has been working on integrating CI and EE.

    To the Original Poster, I’d just urge caution when using EE relationships. With the number of products you have it probably won’t be a concern, but we did a tool that had something like 70,000 products and related them to a weblog of company names and addresses, and the exp_relationships table got huge… at one point our total database was 1 gig, and 900 megs of that was the exp_relationships table!

    Bottom line is that EE isn’t a data mining tool (nor was it ever meant to be). If you plan on growing, you might want to look into some other tool to run side by side with EE.

    Just my $0.02

  • #17 / Dec 18, 2007 3:30pm

    jschutt

    452 posts

    Pete,

    Thanks for the caution!  Good thing I only have about a hundred products, not 70,000.

    I think my point with this thread is still to see how people deal with tabular data in EE.  I am faced with a particular issue and am interested to see how others are getting their tables into EE.

    It would really be nice if we would be able to assign custom fields to each entry on the fly, instead of each weblog. 

    Jesse

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

ExpressionEngine News!

#eecms, #events, #releases