It is possible , and speed will be nice. two points : check for exploding index. if you have 20 tags in one entity and if you query for four or five tags, you may hit this limit.
2 : for millions of entitty, you might want to use shorter name for entity property, it can save lots of space. On Sep 10, 3:38 pm, Smrchy <[email protected]> wrote: > Hi, > > we are in the planning phase of an app we would like to do with App Engine. > > The app will have millions of data records / entities like this: > > ID (String) > Name (String) > Title (String) > Description (String) > CreatedDate (Datetime) > Tags (StringListProperty) (Example: music, sport, travel, New York, USA, > 2010) > > We need the following search options: > > - by a single tag (Example: 'sport') > - by 2+ tags (Example: 'sport' and 'USA' and '2010') > > All searches should return max. 200 records and be ordered by CreatedDate in > reverse order. > It should be possible to limit the searched records by the CreatedDate (e.g. > > > 2009/06/01 and < 2009/09/01) > > My question is this: Can this be done efficiently with the Datastore. By > efficiently i mean the response times should be below 1-2 seconds, even with > millions of rows. > > Does anyone have experience with this scenario? > > Do you have and hints what we should look for or avoid? > > Thanks for your help > Patrick -- 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.
