[jboss-user] [EJB/JBoss] - read-ahead and optimization

[kanth_seenu]

4.0.1sp1 version of jboss. 

In order to optimize the execessive queries fired to database by getter methods, I tried using the read-ahead tag. I have given the details about my configuration

* @jboss.load-group
  | *  name="modules"
  | * description="module fields used in query"
  |  * @jboss.read-ahead strategy = "on-find"
  |  * page-size = "200"
  |  * eager-load-group="modules"
  | 
  |  * @ejb.finder
  |  *    signature="java.util.Collection findByTaskId(java.lang.Long taskid)"
  |  *    query="SELECT DISTINCT OBJECT(o) FROM Task o WHERE o.taskid = ?1"
  |  *    description=""
  |  * @jboss.query
  |  *    description="This generates jboss-ql and overwrites the original query "
  |  *    signature="java.util.Collection findByTaskId(java.lang.Long taskid)"
  |  *    query="SELECT DISTINCT OBJECT(o) FROM Task o WHERE o.taskid = ?1"
  |  *      eager-load-group="modules"
  |  *      strategy="on-find"
  |  *      page-size="200"

Add added @jboss.load-group name="modules" to my getter methods

but still I don't see any cache/optimization happening with my sql queries, issue persists

I have also removed the readonly attribute that I had set to the getter methods.

How to use the read-ahead attribute?



View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4016243#4016243

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4016243