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.

Fieldframe checkbox fieldtype vs. plain old category - Performance Difference?

January 14, 2010 7:10pm

Subscribe [2]
  • #1 / Jan 14, 2010 7:10pm

    negs

    43 posts

    Hi…

    For a site I am working on, I am using Brandon Kelly’s fieldframe and using a checkbox field type to let my client choose groups.

    ie. in a weblog called ‘books’, there are three checkboxes: childrens, history, sports

    Then, in a template, I say,

    {exp:weblog:entries weblog="books"}
    {if {book-type:selected option="history"}}
    
    {title}
    
    {/if}
    {exp:weblog:entries}

    Is there a significant performance hit doing it this way, vs using categories for the three groups, like this:?

    {exp:weblog:entries weblog="books" category="4"}
    
    {title}
    
    {exp:weblog:entries}

    I use the checkboxes because it is easier for a client to enter content when they just have to use the publish form, and don’t have to click on the categories tab. I assume there is a performance hit, because the loop has to iterate through all of the entries, and then do an ‘if’ on each one, vs doing a query before we start iterating. But when will I start to notice a difference? 100 entries? 1000? 100000?


    Thanks.

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

ExpressionEngine News!

#eecms, #events, #releases