1. How do I delete indexes? I removed all but 3 indices for a class in
the index.yaml file. I uploaded this last night but there are still 9
indices shown as serving in the dashboard (none are marked for
deletion).

2. The following behaviour started occuring last night (we've been
live for a couple of weeks). I believe it started when I introduced a
new (unrelated) index on the table. The following code has not changed
in months. The following code is called for a user's inbox and sent
mail. Now these non-deterministically return records.

In debugging this I changed both DESC to ASC and uploaded it. Only the
from_member query returned all the records. The other returned none. I
uploaded it again sorted on a different date field and the other query
returned records. The data hasn't changed (all fields are non-null).

@classmethod
 def get_mail_to_member(cls, member, limit=10, offset=0):
        return Mail.gql("WHERE to_member = :1 AND is_active_to_member
= :2 ORDER BY sent_date DESC", member, True).fetch(limit,
offset=offset)

  @classmethod
  def get_mail_from_member(cls, member, limit=10, offset=0):
        return Mail.gql("WHERE from_member = :1 AND
is_active_from_member = :2 ORDER BY sent_date DESC", member,
True).fetch(limit, offset=offset)

Has anyone seen this before? I want to clear out all extraneous
indices on this table (see question 1).

Thanks!
Natalie Gordon
http://lenguajero.com
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to