1 Reply Latest reply on Apr 25, 2006 10:10 AM by ejb3workshop

EJB3.0 inefficient Query why?

kidder_whw Apr 23, 2006 11:50 PM

I have a table have one million record, when use page to browse data from table. pagesize 10.
first page: 16ms
1000 page: 600ms
...
10000 page: 1760ms
...

why?

how EJB efficient?

1. Re: EJB3.0 inefficient Query why?

ejb3workshop Apr 25, 2006 10:10 AM (in response to kidder_whw)

Could you please post a little bit more information. A code snippet and the database schema , index could be useful.
Actions