JpaContainer too many sqls,can i use paging like limit 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.

I think that this is not possible. I had a similar problem with controlling performance - solved it by giving up JPACOntainer.and implement my own services.