11 | Iterating over large result set"); for (Tuple t : q.setFirstResult(page).setMaxResults(pageSize).getResultList()) { // work |
11 | 100% CPU when using multiple BETWEEN to the first 50 records with Query.setMaxResults(...). Any suggestions? Thank you Emil prolancer Emil |
11 | Retrieve latest entry in a time-series result only: return em.createQuery("...").setMaxResults(1).getSingleResult(); support Support |
11 | Query perfromance problem).setMaxResults(count).getResultList(); logger.debug("Query executed"); } catch |
11 | LIMIT or TOP functionsIs there LIMIT or TOP functions in object db? If so can you provide some examples? vinodh vinodhkumar You can set query result range by using the setFirstResult and setMaxResults methods. You can find more details and an example in the manual. support Support Thanks. This solved my purpose. vinodh vinodhkumar |
11 | Left join fetch behaviour doesn't retrieve children? = query.setMaxResults(10000).getResultList(); Long end = new Date().getTime(); Long |
2 | Null pointer exception being thrown from within ObjectDB. { *****POINT OF FAILURE***** */ reportDownloadObjects = query.setMaxResults(maxRecords |
2 | Issue with cascade delete & add/remove(); contact = (Contact) em.createQuery("SELECT FROM Contact") .setMaxResults(1 |
