I would like to request some clarification on whether the following
model with the set of queries result in an exploding index.
I am trying to build a quick stock notes application where we want to
add some quick notes on stocks. Stocks and Tags are both list
properties. But I will not make any query that include both tags and
stocks at the same time. Only ONE at a time combined with created in
desc order (to get last one first).
I imposed a restriction of ONLY A MAX of 3 tags allowed for any row
( same is the case with 3 stocks, restricted to max of 3)
class QuickNote(db.Model):
description = db.StringProperty()
author = db.StringProperty()
status = db.StringProperty()
tags = db.StringListProperty()
stocks = db.StringListProperty()
created = db.DateTimeProperty(auto_now_add=True)
Index :
- kind: QuickNote
properties:
- name: tag
- name: created
direction: desc
- kind: QuickNote
properties:
- name: stock
- name: created
direction: desc
1. A single entity will never have more than 3 values in each list and
never more than one list property is used in a single query. However,
I need to combine with date in desc order to retrieve latest notes.
(as shown above)
2. As a whole, we might have about 1000 stocks and similar range of
tags.
I would like to know if this data model with the given set of queries,
will result in exploding index?
Also, if I have 7 more (a total of 9) different List properties
(similar to stocks and tags) each with the same restriction of 3
values in a list, and they are never combined (except with date in
desc order), would that result in exploding index? At any time only 2
or 3 lists will have any values filled in.
Thank you very much in advance for your inputs.
Murali
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
