Internal Website Search

11-20 of 23 resultsRefresh

About LIMIT and OFFSET as query tokens

_setfirstresult_setmaxresults">setFirstResult and

Performance problem

e", AktImpl.class);         queryAkt.setFirstResult(i ... );         queryAkt.setFirstResult(i); queryAkt

Listing large number of complicated objects with paging.

= icQuery.setFirstResult(start).setMaxResults(count).getResultList(); is quite slow ... ;  query.setFirstResult(20).setMaxResults(10).getResultList();      

Caching/Paging Questions...

> Would paging result sets via setFirstResult and setMaxResult speed up the query execution since there are fewer ... ;There is no limit on the maximum size of the L2 cache. Using setFirstResult and setMaxResults

Server closes if large query runs out of memory

, consider setfirstresult_setmaxresults">limiting

slow performance for a complex query

. However if I do that, I cannot support pagination over result set with setFirstResult and setMaxResults

Sorting problem

Branch: 113 The same if I use setFirstResult() and setMaxResult();  

NPE at com.objectdb.jpa.JpaQuery.getResultList

.setMaxResults(maxResults); q.setFirstResult(firstResult); } return q ... ;     q.setFirstResult(firstResult);        

[ObjectDB 2.2.5_02] Unexpected exception (Error 990) com.objectdb.o.InternalException: java.lang.NullPointerException: null

(maxResults); q.setFirstResult(firstResult); } return q

Unexpected Exception (Error 990) with ArrayIndexOutOfBoundsException

.class); query.setFirstResult(50000); final List<EventLogPersistEntry> results