Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=3702123 By: t_venkatesh
Hi, I am working on a project where I am making use of Hibernate for the first time. I am also using displayTag When I am suppose to display 1000+ records [say 20 record/page], the pages are loading very slowly. Also, I find the querry getting fired every time I move on to the next page. My idea of effective fetching and displaying 1000s of records is fire the querry once and iterate through the list for every page without hitting the database. Is this idea practicaly feasible ? If yes, can you give me hints how to implement the same. In short I do not want to hit the database again and again or Is it possible to fetch only first 20 records for the first page and then fetch next 20 records for next page and so on. Kindly share your expertise. Thanks in advance. Details: Hibernate version: 3.0 Name and version of the database you are using: Oracle 9i The generated SQL (show_sql=true): select MIN(sbbid0_.PER_HOUR_RATE) as col_0_0_, sbbid0_.REQ_LINE_ITEM_ID as col_1_0_, sbbid0_.REQUIREMENT_ID as col_2_0_ from BID sbbid0_, REQ_LINE_ITEM sbreqlinei1_ where (sbbid0_.BID_STATUS_CODE in (10 , 40 , 50 , 60 , 61 , 70 , 80 , 90 , 95 , 33 , 43)) and (sbbid0_.BID_STATUS_CODE not in (33 , 43)) and sbbid0_.DELETION_MARK=0 and sbbid0_.FIT_PERCENTAGE>=sbreqlinei1_.THRESHOLD_OF_FIT and sbreqlinei1_.DELETION_MARK<>1 and sbbid0_.COST_OF_SKILLS>=(select min(sbbid2_.COST_OF_SKILLS) from BID sbbid2_ where sbbid2_.REQ_LINE_ITEM_ID=sbreqlinei1_.REQ_LINE_ITEM_ID and sbbid2_.REQUIREMENT_ID=sbreqlinei1_.REQUIREMENT_ID and (sbbid2_.BID_STATUS_CODE in (10 , 40 , 50 , 60 , 61 , 70 , 80 , 90 , 95 , 33 , 43)) and (sbbid2_.BID_STATUS_CODE not in (33 , 43)) and sbbid2_.DELETION_MARK<>1 and sbbid0_.REQ_LINE_ITEM_ID=sbbid2_.REQ_LINE_ITEM_ID and sbbid0_.REQUIREMENT_ID=sbbid2_.REQUIREMENT_ID and sbbid0_.BID_ID=sbbid2_.BID_ID) group by sbbid0_.REQ_LINE_ITEM_ID , sbbid0_.REQUIREMENT_ID ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=249317 ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ displaytag-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/displaytag-user
