Hi, While we would like to make search of the datastore more efficient in the future, composite indexes with App Engine will most likely always exist with App Engine.
For more information about indexes & App Engine, I'd suggest reading the article on how index building works: http://code.google.com/appengine/articles/index_building.html and watching "Under the covers of the App Engine datastore" from Google I/O: http://sites.google.com/site/io/ -Marzia On Thu, Nov 27, 2008 at 9:52 AM, tigrillo < [EMAIL PROTECTED]> wrote: > > It also happen when ordering by some other attribute; it will be > posible to avoid the need of that indexes in next versions of GAE? > > On 19 nov, 14:10, Marzia Niccolai <[EMAIL PROTECTED]> wrote: > > Hi, > > > > This is expected behavior. When adding the filter, a composite index is > > created for the query. The composite index lists one > > __searchable_text_index for the number of terms in your search query. > > > > -Marzia > > > > On Wed, Nov 19, 2008 at 7:51 AM, ravindra <[EMAIL PROTECTED]> wrote: > > > > > Hi, > > > > > I have created class Record as follows : > > > > > class Record(search.SearchableModel): > > > exp_year = db.IntegerProperty() > > > keywords = db.StringProperty(multiline=True) > > > > > now when i am running the following query in dev version : > > > query = Record.all().search("first second third fourth" ) > > > > > then index file gets updated as single entry for > > > __searchable_text_index > > > - kind: Record > > > properties: > > > - name: __searchable_text_index > > > - name: exp_year > > > > > if i modify the query to this (added the filter clause) > > > query = Record.all().search("first second third" ).filter("exp_year >", > > > 1) > > > > > the index file get updated with multiple entries for > > > __searchable_text_index > > > - kind: Record > > > properties: > > > - name: __searchable_text_index > > > - name: __searchable_text_index > > > - name: __searchable_text_index > > > - name: exp_year > > > > > The number of entries for __searchable_text_index then directly > > > depends on the number of keywords searched for. > > > But in earlier query (ie without filter) it does not depend on the > > > number of keywords. > > > Am I putting query wrong somewhere ? or is it expected behaviour ? > > > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
