Well, there is one issue from the start. See the section titled
"Inequality Filters Are Allowed On One Property Only"
http://code.google.com/appengine/docs/python/datastore/queriesandindexes.html#Restrictions_on_Queries
It can be very tricky to perform diverse ad-hoc queries on App Engine.
If you have a good understanding of your data and how users will
_usually_ want to interact with it, you can design for the
limitations. For example, one possible way to handle the 'two
inequality' issue: add a boolean property, 'a_less_than_50', that you
can query on. You will very likely need to do some degree of in-app
filtering. To handle some complex queries you might need to use tasks
to process your data and build the result set.
As far as the size goes, you should not have any issues. I would
suggest you read up on how the datastore works though. Google has
posted some articles that are a very good starting point:
http://code.google.com/appengine/articles/datastore/overview.html
Robert
On Sat, Nov 27, 2010 at 21:56, 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.
>
>
--
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.
