Re: [google-appengine] Google App Engine datastore supports only 200 indexes..
Will that mean, an application can not have "complex queries" more than 200? I have a situation where I am searching on 7 different parameters (search filter of 8 different parameters) and then need to sort the results in 80 different columns in the table (by one at a time). That shall mean 7 + 1 indexes for a sort per field (Ascending, and 8 more for descending) X 80. which is a huge number. Is there a way out or I need to sort the list programatically? Thanks Aadhaar On Saturday, February 26, 2011 6:19:56 PM UTC+5:30, Ian Lewis wrote: > > Hi, > > The number if indexes isn't affected by the number of properties on an > entity. It only has to do with the number of indexes for "complex queries" > that are needed in your application (i.e. Those in index.yaml). So the > number of indexes created automatically (by properties on indexes) are > probably only limited by your available storage and doesn't limit the > number of entities or properties on entities. > > See: > http://code.google.com/appengine/docs/python/config/indexconfig.html > http://code.google.com/appengine/docs/python/datastore/propertyclass.html > > On Sat, Feb 26, 2011 at 7:19 PM, piplayan nayak > > > wrote: > >> I am a newbie to app engine datastore. I am currently evaluating migrate >> my existing webapp to app engine. >> I found that the hard limit for indexes is 200 for an application. >> So, i am really confused whether this constraint forces many limitations >> on the app engine datastore design.[ for eg. no of entity kinds, no of >> properties in an entity] etc. >> >> Please advice me on this >> >> -- >> 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-a...@googlegroups.com >> . >> To unsubscribe from this group, send email to >> google-appengi...@googlegroups.com . >> For more options, visit this group at >> http://groups.google.com/group/google-appengine?hl=en. >> > > > > -- > Ian > > http://www.ianlewis.org/ > -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-appengine+unsubscr...@googlegroups.com. To post to this group, send email to google-appengine@googlegroups.com. Visit this group at http://groups.google.com/group/google-appengine. For more options, visit https://groups.google.com/groups/opt_out.
Re: [google-appengine] Google App Engine datastore supports only 200 indexes..
Hi, The number if indexes isn't affected by the number of properties on an entity. It only has to do with the number of indexes for "complex queries" that are needed in your application (i.e. Those in index.yaml). So the number of indexes created automatically (by properties on indexes) are probably only limited by your available storage and doesn't limit the number of entities or properties on entities. See: http://code.google.com/appengine/docs/python/config/indexconfig.html http://code.google.com/appengine/docs/python/datastore/propertyclass.html On Sat, Feb 26, 2011 at 7:19 PM, piplayan nayak wrote: > I am a newbie to app engine datastore. I am currently evaluating migrate my > existing webapp to app engine. > I found that the hard limit for indexes is 200 for an application. > So, i am really confused whether this constraint forces many limitations on > the app engine datastore design.[ for eg. no of entity kinds, no of > properties in an entity] etc. > > Please advice me on this > > -- > 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. > -- Ian http://www.ianlewis.org/ -- 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] Google App Engine datastore supports only 200 indexes..
I am a newbie to app engine datastore. I am currently evaluating migrate my existing webapp to app engine. I found that the hard limit for indexes is 200 for an application. So, i am really confused whether this constraint forces many limitations on the app engine datastore design.[ for eg. no of entity kinds, no of properties in an entity] etc. Please advice me on this -- 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.
