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.
