GAE is not designed for performing complex queries on a dataset. It is possible to get it to work by anticipating what queries you will need and building the corresponding indexes, but it is not easy nor flexible, and the complexity of the queries would be limited.
Why not start with a relational database ? 10 millions rows doesn't sound like it would be slower than GAE. Not sure about your use case but BigQuery also looks like a possibility: http://code.google.com/apis/bigquery/docs/overview.html On Nov 28, 11:56 am, smitts <smitt...@gmail.com> wrote: > I'm considering using GAE to host a relatively large (10 Million+ > rows, possibly larger) database. Data from this database is then > retrieved using filter criteria on multiple columns of the table and > displayed to the user. Typically the criteria is (column a < 50) && > (10 < column b < 1000) && (column c == true), which has been > relatively database intensive on a traditional LAMP. > > Does anyone have experience running a similar setup? Most of what I > have seen GAE used for is much less database intensive. Could it > work? Should I expect faster or slower responses from the LAMP? > > Thanks! -- 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-appeng...@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.
