Hi, I want to store 4.5 million data records that have a string identifier which each have 50 keywords associated with them.
For example, value (string), keyword1 (string) ... keyword50 (string) In SQL Server 2008 in a traditional database the best way, that I found, was to store this is 3NF such as value_id (int) value (string) | | value_id (int) keyword_id (int) | | keyword_id (int) keyword_value (string) The data is mostly static, I typically use queries where to find values which use specific keywords, which in SQL uses IN queries, however I'm not sure if this is the best approach for the app engine datastore. Do people recommend the data stored as- value, keyword0, keyword1, keyword2 etc.. or in the same sort of way as I store it in SQL Server? What would the performance be using the app engine be for this store of datastore if I wanted to find values which have say 2 specific keywords? Thanks, Gary --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to google-appengine@googlegroups.com To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en -~----------~----~----~----~------~----~------~--~---
