14 | Caching/Paging Questions... via setFirstResult and setMaxResult speed up the query execution since there are fewer result objects to bring into ... . Using setFirstResult and setMaxResults could improve performance, but the effect is highly dependent on the specific query. support Support |
14 | Performance problem); queryAkt.setFirstResult(i); queryAkt.setMaxResults(20); queryAkt ... AktImpl e", AktImpl.class); queryAkt.setFirstResult(i); queryAkt.setMaxResults |
10 | Selecting random rowsHello is there way to get random rows? Functions like rand(), random(), newid() doesn't work ;/ for example: em.createQuery("SELECT s FROM StawkaVat s ORDER BY rand()").setMaxResults(5).getResultList(); gives exception: Exception in thread "AWT-EventQueue-0" [ObjectDB 2.5.6_02] SELECT s FROM |
10 | Sorting problem() and setMaxResult(); lwalkowski Lukasz Walkowski Your query works well with a small change |
10 | Mapped By Fetch is very Slow.setMaxResults(10000).getResultList(); Long end = new Date().getTime(); Long duration = (end |
10 | New to Product & Having An Issue = em.createNamedQuery("Department.findAll", Department.class); q.setMaxResults(1000 |
10 | Query perfromance problem).setMaxResults(count).getResultList(); logger.debug("Query executed"); } catch |
10 | 100% CPU when using multiple BETWEEN to the first 50 records with Query.setMaxResults(...). Any suggestions? Thank you Emil prolancer Emil |
10 | About LIMIT and OFFSET as query tokens Thanks you in advance mgarciat Miguel In JPA you specify a result range using setFirstResult and setMaxResults. support Support Thanks you!!! mgarciat Miguel |
2 | Null pointer exception being thrown from within ObjectDB. { *****POINT OF FAILURE***** */ reportDownloadObjects = query.setMaxResults(maxRecords |
