[google-appengine] Re: maximum number of values in all indexes for an entity -what is it?

2011-05-10 Thread lp
yeap the production server is different to the dev environment.

i am getting the following error in prod when adding a to a list of 2500 to 
the entity.

: com.google.apphosting.api.ApiProxy$ApplicationException: ApplicationError: 
1: Too many indexed properties for entity: app: 

however this is well short of the 5000 hard limit advertised.

any idea where the other 2500 indexes are being used?

-lp

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



[google-appengine] Re: maximum number of values in all indexes for an entity -what is it?

2011-05-09 Thread PandaSuit
My understanding is that the limit is as you described so a 5002 entry
list property will require 5002 entries in the index. If you have
multiple list properties then the number of index entries may be a
cross product if the index contains more than one list property (try
to avoid this).

I am guessing the reason the dev server is letting you have 5002
entries is that the dev server does not actually enforce the limits of
the production server in many cases (especially with regard to
indexes). One to watch out for is exploding indexes where the dev
server will automatically create the index definitions for you and
continue to operate fine even if you have a query requiring an
exploded index (because the dev server does not use those indexes) but
once you upload to the production server your index will probably fail
to be created.

Side note: Does anyone know of a list that details the known
differences between the dev server and the production server?

- Bryce


On May 9, 1:56 am, lp  wrote:
> hi guys
> i am attempting to understand the limits below.
>
> seehttp://code.google.com/appengine/docs/java/datastore/overview.html
>
>  Limit      
>
>   maximum entity size 1 megabyte  maximum number of values in all indexes
> for an entity (1) 5,000 values  
>
>    1. An entity uses one value in an index for every column × every row that
>    refers to the entity, in all indexes. The number of index values for an
>    entity can grow large if an indexed property has multiple values, requiring
>    multiple rows with repeated values in the table.
>
> i am not sure what it means.
>
> i thought the limit would apply to list properties, but my test of 5002
> elements in a list was successful in the
> dev environment.
>
> any help in clarifying what the limit means is helpful
>
> thanks
>
> -lp

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