It all was in production. And I have right indexes at that moment (actually had :), when i've done smth wrong with indexes when tried to fix it, now they marked as error. I tried to vacuum indexed by instruction, but they marked as error near 20 hours :( )
On Jun 26, 2:26 pm, "Nick Johnson (Google)" <[email protected]> wrote: > Hi buger, > > Is this in production, or on the dev_appserver? In production, your > app does not appear to have the necessary indexes to execute the > second query. > > -Nick Johnson > > On Thu, Jun 25, 2009 at 11:38 PM, buger<[email protected]> wrote: > > > SELECT * FROM Video WHERE artist = Key > > ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM') AND > > status = 2 > > This query gives me 4 results > > > But this gives only 1 result!, i'm just added order > > SELECT * FROM Video WHERE artist = Key > > ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM') AND > > status = 2 ORDER BY created_at desc > > > created_at is DateTime property, and all this objects have it > > -- > Nick Johnson, App Engine Developer Programs Engineer > 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en -~----------~----~----~----~------~----~------~--~---
