Hi,
I have an entity kind that inherits from SearchableModel which has 13,417,423
Entities whose single property indexes I disabled (Indexed=False).
I have no composite indexes on this kind and all queries made on this kind
is via basic seach.
*entities =
Kind.all().search(searchQ).fetch(self.PAGE_SIZE,offset=self.getPageOffset())
*
Searches do work well apart from certain specific search terms that fail
with error
*NeedIndexError: The built-in indices are not efficient enough for this
query and your data. Please add a composite index for this query.*
Exception trace is attached.
Am an intermediate with App Engine development. Any help is appreciated.
--
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.
Traceback (most recent call last):
File
"/base/python_runtime/python_lib/versions/1/google/appengine/ext/webapp/__init__.py",
line 515, in __call__
handler.get(*groups)
File "/base/data/home/apps/gaeapp/1.348515439657710467/BasePage.py", line 20,
in get
self.__doProcess()
File "/base/data/home/apps/gaeapp/1.348515439657710467/BasePage.py", line 32,
in __doProcess
self.OnLoad()
File "/base/data/home/apps/gaeapp/1.348515439657710467/SearchPage.py", line
15, in OnLoad
entities =
Kind.all().search(searchQ).fetch(self.PAGE_SIZE,offset=self.getPageOffset())
File
"/base/python_runtime/python_lib/versions/1/google/appengine/ext/db/__init__.py",
line 1833, in fetch
raw = raw_query.Get(limit, offset, config=config)
File
"/base/python_runtime/python_lib/versions/1/google/appengine/api/datastore.py",
line 1352, in Get
batch = batcher.next_batch(limit)
File
"/base/python_runtime/python_lib/versions/1/google/appengine/datastore/datastore_query.py",
line 1121, in next_batch
batch_size=batch_size))
File
"/base/python_runtime/python_lib/versions/1/google/appengine/datastore/datastore_query.py",
line 935, in next_batch
return async.get_result()
File
"/base/python_runtime/python_lib/versions/1/google/appengine/api/apiproxy_stub_map.py",
line 534, in get_result
return self.__get_result_hook(self)
File
"/base/python_runtime/python_lib/versions/1/google/appengine/datastore/datastore_query.py",
line 1013, in __query_result_hook
self.__conn.check_rpc_success(rpc)
File
"/base/python_runtime/python_lib/versions/1/google/appengine/datastore/datastore_rpc.py",
line 977, in check_rpc_success
raise _ToDatastoreError(err)
NeedIndexError: The built-in indices are not efficient enough for this query
and your data. Please add a composite index for this query.
