Issue Details (XML | Word | Printable)

Type: New Feature New Feature
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Andy Jefferson
Reporter: Andy Jefferson
Votes: 0
Watchers: 0

If you were logged in you would be able to see more operations.
DataNucleus Store RDBMS

Support "count" query for obtaining size of JDOQL results for large result sets

Created: 01/Aug/08 07:35 AM   Updated: 22/Sep/08 02:05 PM   Resolved: 01/Aug/08 07:56 AM
Component/s: Queries
Affects Version/s: None
Fix Version/s: 1.0.0.m4

 Description  « Hide
When we have a large result set, it would be beneficial to allow a query
SELECT count(this) FROM ...
to get the number of results for a query. Saves loading up instances

Andy Jefferson added a comment - 01/Aug/08 07:56 AM
SVN trunk supports query extension "datanucleus.query.resultSizeMethod" value of "count" and will perform a count() query to get the size rather than navigating to the last object (and instantiating all in the process!)

Andy Jefferson made changes - 01/Aug/08 07:56 AM
Field Original Value New Value
Status Open [ 1 ] Resolved [ 5 ]
Resolution Fixed [ 1 ]
Andy Jefferson made changes - 22/Sep/08 02:05 PM
Status Resolved [ 5 ] Closed [ 6 ]