0 Replies Latest reply on May 22, 2009 11:46 PM by gzoller.greg.zoller.aviall.com

    Large Table Performance

    gzoller.greg.zoller.aviall.com
      Hello,

      I am trying to performance-tune a large table.  For the purposes of my tuning I created a "labs" page that populates 1000 rows of canned data (no db-hits).  It's as basic as I could get.  I'll show my code then my performance numbers.  I also attempted to follow the tuning guidelines in this [article=>http://jsfcentral.com/articles/speed_up_your_jsf_app_1.html]

      Java:

      `@Name("orderMgr")
      @Scope(ScopeType.SESSION)
      public class OrderMgr {
           @Out (required=false) private Order order;
           private int count = 1000;
           public OrderMgr() {this.order = new Order(count);}
           public int getCount() {return count;}
           public Order getOrder() {return this.order;}
      }
      `

      XHTML:
      `<rich:dataTable id="table"
           immediate="true"
           cellpadding="0" cellspacing="0"
           border="0" var="item" value="#{sessionContext.get('order').lines}">
           <rich:column>
                <f:facet name="header">Num</f:facet>
                <h:graphicImage id="lineInvalid" value="/img/invalid.gif"/>
                <h:outputText id="lineNum" value="#{item.number}" />
           </rich:column>
           <!-- other columns -->
      </rich:dataTable>
      `