ADF : Performance Tips

ADF : Performance Tips

#################################################################################

getRowCount() -> getRowCount() retrives all the records from View Object by executing ViewObject Query.The count is calculated by traversing the Viewobject using next() method until the
last record is retrived. This method hinders the performance of application in case of VO with large number of rows.

getEstimatedRowCount() -> When you need to get quick count of row.Use this method. Method getEstimatedRowCount() actually retrives the count by hitting getQueryHitCount() which runs the select count(*) on the VO query.

getFetchedRowCount() -> Method getFetchedRowCount() counts the number of rows from the Result Set.Returns the number of rows fetched at that point of time.

#################################################################################

Table column -> id="c3" "filterFeatures" attribute not set

 #################################################################################

BindingSection -> TableIterator -> RowCountThresholds for the above tables should be set to -1