I am consider the same app now. How about the performance of - 100tags in one entity - 10 tags in one query ( only AND, no OR ) - return 10 from millions entities
will the reponse time be under 1-2 second? On 9月12日, 上午10时57分, gops <[email protected]> wrote: > 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.
