CODEWITHSUNDEEP
javagoogle-app-enginegoogle-cloud-datastoredatanucleusgae-eclipse-plugin
learner
learner

Reputation: 11780

Are there restrictions on GAE Datanucleus * query

Does anyone know if there are any restrictions to using * queries in datanucleus JPA for the google app-engine (GAE) datastore? My query is

SELECT * FROM Pen p WHERE p.owner = :owner order by p.price desc

I need to assemble a list of Pen entities/objects and associated data to send to client. I can't do key only because I need the actual entities. But I often here of the slowness of * queries in relational databases.

I already have the table/entity indexed on owner and price

Upvotes: 0

Views: 33

Answers (1)

Neil Stockton
Neil Stockton

Reputation: 11531

You mean apart from the fact that "SELECT *" is illegal in JPQL? If you put "SELECT p FROM ..." then fine. Google's Java docs defines what their datastore supports, i.e no joins. And this is Google's datastore and their plugin doing the querying NOT 'DataNucleus'

Upvotes: 0

Related Questions