Hi, >From what you have explained, it doesn't appear as though you will have an issue with exploding indexes, provided you don't start running queries on multiple StringListProperties, and your overall entity definition does not have a lot of properties. This is typically where applications start to have issues.
-Marzia On Sat, Jan 17, 2009 at 11:05 AM, Murali <[email protected]> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
