JIQL

12 views
Skip to first unread message

Paul Jacobs

unread,
Jan 20, 2010, 1:18:42 PM1/20/10
to jiql
Does JIQL support GROUP BY? With large numbers of entities?

Does it support JOINS as long as care is taken for compound keys and
the like?

Gabriel Wong

unread,
Jan 21, 2010, 6:40:49 PM1/21/10
to jiql
It should support your JOINs. Note you are limited to 30 seconds
between request and response on App Engine.
So you may want to avoid too complex queries.

GROUP BY is not yet implemented, although jiql will just ignore the
clause
instead of throwing an exception.

Paul Jacobs

unread,
Jan 22, 2010, 1:11:08 PM1/22/10
to jiql
I'm struggling with whether to become deeply engaged with JIQL in
order to get around some of the core limitations that the Google
datastore has for my type of app.

The 1000 entity thing is a major issue. You have some sort of table
'leafing' in JIQL to help get around it. Is this technique described
anywhere?

Gabe Wong

unread,
Jan 24, 2010, 11:43:14 PM1/24/10
to ji...@googlegroups.com
jiql Table Leafs is a feature that is enabled by default. So it
should be transparent to you.

More info can be found here:
http://docs.google.com/Doc?id=dhg923vj_2ghr8q9f3

> --
> You received this message because you are subscribed to the Google Groups "jiql" group.
> To post to this group, send email to ji...@googlegroups.com.
> To unsubscribe from this group, send email to jiql+uns...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/jiql?hl=en.
>
>

Reply all
Reply to author
Forward
0 new messages