Thank you for your reply. I was worried it would result in exploding index and I may have to redesign the whole Model. And I could not come up with an alternate way to achieve the same functionality.
Murali On Jan 20, 1:48 pm, Marzia Niccolai <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
