On Wed, Oct 14, 2009 at 1:53 PM, Dinesh <dinesh.varadhara...@orangescape.com > wrote:
> > Hi Nick, > > Not functioning how? > I want to reuse existing apps, so I cleared data and indexes. I am not > seeing any data in data viewer or any index in indexes. But when > trying to import new app I am getting index quota error.. I just got > the alert saying deleting app is possible now. Thank god.. > Do you still need these apps reset, now that you can delete them and create new ones instead? > > > Are all of these apps out of index quota? > Yes > > > Requiring more than 100 indexes is usually a sign of a schema design that > > needs optimizing. We can increase the index quota, but only in > exceptional > > circumstances. > We store the data in expando model which is very huge.. The no of > columns at the minimum will be around 300. The auto generated indexes > are around 50% of total indexes. In addition, gae throws "need index > error" in lot of cases and we end up adding those indexes in to > index.yaml. So, it easily crosses the limit.. > Without knowing more about your data model, it's impossible to comment on how you can reduce your total number of indexes. -Nick Johnson > We don't use any of the inequality filters in our queries except in 2 > cases. > Thanks, > Dinesh > > > On Oct 14, 4:33 pm, "Nick Johnson (Google)" <nick.john...@google.com> > wrote: > > Hi dinesh, > > > > On Wed, Oct 14, 2009 at 12:00 PM, Dinesh < > > > > dinesh.varadhara...@orangescape.com> wrote: > > > > > Hi Nick, > > > thanks for the immediate reply.. I cleared data and vacuumed indexes > > > in 4 of my apps. (Created new apps as old apps are not functioning). > > > > Not functioning how? > > > > > But still it is throwing the quota exception. The app ids are > > > > > os-demo > > > osruntime > > > osclouddemo > > > osruntime > > > > Are all of these apps out of index quota? > > > > > > > > > And we might be terribly needing support for more than 100 indexes for > > > our apps and are ready to pay for the overuse. I don't think it is > > > part of billing. any thoughts of including it.. > > > > Requiring more than 100 indexes is usually a sign of a schema design that > > needs optimizing. We can increase the index quota, but only in > exceptional > > circumstances. > > > > > > > > > Thanks, > > > Dinesh > > > > > On Oct 14, 3:52 pm, "Nick Johnson (Google)" <nick.john...@google.com> > > > wrote: > > > > Hi Dinesh, > > > > All apps are limited to 100 indexes. If you are getting this error on > an > > > app > > > > that has fewer than 100 indexes, please let me know which one it is, > and > > > I > > > > will reset your index count quota. > > > > > > -Nick Johnson > > > > > > On Wed, Oct 14, 2009 at 11:50 AM, Dinesh < > > > > > > dinesh.varadhara...@orangescape.com> wrote: > > > > > > > Hi, > > > > > Suddenly I am getting > > > > > > > "Over index creation quota: The API call datastore_v3.CreateIndex() > > > > > required more quota than is available." > > > > > > > when trying to update indexes. however few of my older applications > > > > > has more than 100 indexes it it. Is this limitation newly > introduced > > > > > in gae. If so, how do I increase the quota. > > > > > > > Dinesh > > > > > > -- > > > > Nick Johnson, Developer Programs Engineer, App Engine > > > > Google Ireland Ltd. :: Registered in Dublin, Ireland, Registration > > > Number: > > > > 368047 > > > > -- > > Nick Johnson, Developer Programs Engineer, App Engine > > Google Ireland Ltd. :: Registered in Dublin, Ireland, Registration > Number: > > 368047 > > > -- Nick Johnson, Developer Programs Engineer, App Engine Google Ireland Ltd. :: Registered in Dublin, Ireland, Registration Number: 368047 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---