JpaContainer use paging command

when i use JpaContainer with CachingMutableLocalEntityProvider and hibernate,the log showed so many sqls when the data displays on the page.Can this be optimized by using paging command like mysql limit? i will really appreciate it if any one can help me.