15 | Listing large number of complicated objects with paging.. Could you please provide more details about the effect of restricting the result range? How many products ... during query processing. This optimization is disabled now (build 2.3.3_06) for range queries, since before sorting and cutting the requested range it is unknown which objects are really needed. Thank |
12 | Explorer in 2.3 to have: 1. Export of selected data: a. Simple - Select a range of cells or a column header and copy ... the results by id ranges (adding additional top levels to the tree, similarly to viewing a very large array |
12 | Standalone server needs dependencies? select statement with a where clause like where t.id=:id and t.range=:range. In fact I just removed |
12 | JPA and handling large data sets to traverse all objects of an entity? Peter pezifromvienna Peter Sauer Using query result range ... and using setMaxResults may be fine. If not check if you can retrieve ranges of objects by setting both lower and upper value. support Support |
12 | performance limit+ records by UserID atribute, tables have from 5 to 20 atributes. Usualy the results range from ... range. Regards. peric.emil Emil Perić With proper indexes defined, queries on millions of objects |
0 | setRange(fromInclToExcl)Method javax.jdo.Query void setRange( String fromInclToExcl ) Set the range of results to return. The parameter is a String containing a comma-separated fromIncl and toExcl. The fromIncl and toExcl ... are ignored. An implementation should execute the query such that the range algorithm |
0 | setRange(fromIncl, toExcl)Method javax.jdo.Query void setRange( long fromIncl, long toExcl ) Set the range of results to return. The execution of the query is modified to return only a subset of results. If the filter ... and the remaining 30 results are ignored. An implementation should execute the query such that the range algorithm |
0 | setUnmodifiable()Method javax.jdo.Query void setUnmodifiable() The unmodifiable flag, when set, disallows further modification of the query, except for specifying the range, result class, and ignoreCache option. The unmodifiable flag can also be set in metadata. Since: JDO 2.0 |
0 | addSubquery(sub, variableDeclaration, candidateCollectionExpression, parameters) with a PersistenceManager, the candidate collection or extent, result class, and range limits are not used |
0 | isUnmodifiable()Method javax.jdo.Query boolean isUnmodifiable() The unmodifiable flag, when set, disallows further modification of the query, except for specifying the range, result class, and ignoreCache option. Returns: the current setting of the flag Since: JDO 2.0 |
