hi guys,
im having the same problem with multiple tags and an order in the query.
so you are saying that without order i wont have exploding indexes even if i
have 20 keywords im filtering on?
when do you think will you finish your work?
thank you!
On Sep 20, 2010, at 3:57 PM, DevShop wrote:
On Mon, Sep 20, 2010 at 12:57 PM, DevShop wrote:
> Wow, thanks Alfred, this is good info.
>
> > - Remove the sort order
> > - Restrict the # of tag= in your query
>
> OR (choose one) or AND (we have to do both)?
>
>
It's OR
Make sure you vacuum the exploding indexes you already have before tryin
Wow, thanks Alfred, this is good info.
> - Remove the sort order
> - Restrict the # of tag= in your query
OR (choose one) or AND (we have to do both)?
If I just have to remove the sort order from the query and manipulate
the keys value then I can live with that. But if I have to also
restrict th
Hi,
This is the quintessential exploding index problem that I am fixing. The
problem is that we don't currently support zigzag merge join and sorting at
the same time. You have several options to address this:
- Remove the sort order
- Slightly worse results until you add it back when I
> Do you have 2 list properties? A single list property won't cause exploding
> indexes. Can you post the whole property?
Thanks for your help!
Do you mean "Can you post the whole class?" ? Here it is, the list
property that explodes is the first property:
class Report(db.Model):
# List
Do you have 2 list properties? A single list property won't cause exploding
indexes. Can you post the whole property?
--
Ikai Lan
Developer Programs Engineer, Google App Engine
Blogger: http://googleappengine.blogspot.com
Reddit: http://www.reddit.com/r/appengine
Twitter: http://twitter.com/app_en
Ikai, thanks for the prompt response.
Here's our situation: records on entity 'Report' are tagged with
multiple keywords ('tags') like: 'music', 'event', 'downtown',
'zz_top', 'concert', 'g_arena', 'september', '2010'. People might
search for events downtown in September like this:
city.domain.co