[appengine-java] Re: Unable to execute query for a large number of entities

2010-07-19 Thread Simon
I believe (and this may be wrong) that the index data is only created
when the object is inserted/updated.  Therefore, any existing data
will be not covered by the new index and won't be retrieved with any
queries which are based upon the index.

Updating them or reuploading them should solve the issue.

On Jul 16, 9:18 am, Ice13ill  wrote:
> I created and uploaded an index for those 2 params:
>
>      source="auto">
>         
>         
>     
>
> After building it i can now execute the query i needed, but i have
> another problem: the retrieved data is incomplete :(
> I run an GQL query in Datastore viewer and the data is there, it seems
> that the app engine sdk does not serve it even with the composite
> indexes.
> Could it help if I reupload the data ? Or if i use low level api to
> get the entities ? (theoretically, it should work right? because it
> seams that the information is not indexed as it should)
>
> On Jul 15, 6:28 pm, Ice13ill  wrote:
>
>
>
> > I uploaded about 100.000 entities into datastore and I need to execute
> > a type of query that shouldn't require composite indexes.
> > But i get this:
>
> > The built-in indices are not efficient enough for this query and your
> > data. Please add a composite index for this query..  An index is
> > missing but we are unable to tell you which one due to a bug in the
> > App Engine SDK
>
> > My entity has three fields (String): type, value, parent so i created
> > an index like this:
>
> > 
> >     > source="auto">
> >         
> >         
> >         
> >     
> > 
>
> > The query uses only equality filters but sometimes only 2 params are
> > used (type and value, let's say)
>
> > Does that meen that i have to create another index ?
> > Or can something else help ?- Hide quoted text -
>
> - Show quoted text -

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.



[appengine-java] Re: Unable to execute query for a large number of entities

2010-07-16 Thread Ice13ill
I created and uploaded an index for those 2 params:






After building it i can now execute the query i needed, but i have
another problem: the retrieved data is incomplete :(
I run an GQL query in Datastore viewer and the data is there, it seems
that the app engine sdk does not serve it even with the composite
indexes.
Could it help if I reupload the data ? Or if i use low level api to
get the entities ? (theoretically, it should work right? because it
seams that the information is not indexed as it should)

On Jul 15, 6:28 pm, Ice13ill  wrote:
> I uploaded about 100.000 entities into datastore and I need to execute
> a type of query that shouldn't require composite indexes.
> But i get this:
>
> The built-in indices are not efficient enough for this query and your
> data. Please add a composite index for this query..  An index is
> missing but we are unable to tell you which one due to a bug in the
> App Engine SDK
>
> My entity has three fields (String): type, value, parent so i created
> an index like this:
>
> 
>     source="auto">
>         
>         
>         
>     
> 
>
> The query uses only equality filters but sometimes only 2 params are
> used (type and value, let's say)
>
> Does that meen that i have to create another index ?
> Or can something else help ?

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.