Comparison with Datastore

173 views
Skip to first unread message

toonetown

unread,
Nov 17, 2011, 4:43:09 PM11/17/11
to Google Cloud SQL discuss
Are there any comparisons of Cloud SQL versus the "standard" Google
AppEngine Datastore? How do they compare with each other performance-
wise?

Steven Roose

unread,
Nov 14, 2012, 6:14:54 PM11/14/12
to google-cloud...@googlegroups.com
Did you find a useful comparison? I'm looking for one myself as well...

Joe Faith

unread,
Nov 14, 2012, 6:28:37 PM11/14/12
to google-cloud...@googlegroups.com
Does this FAQ entry help?
For atomic operations (inserts, updates, reads) performance will be similar.
For more complex queries it depends on the nature of the query.

J

Should I use Google Cloud SQL or the App Engine Datastore?
This depends on the requirements of the application. Datastore provides NoSQL key-value storage that is highly scalable, but does not support the complex queries offered by a SQL database. Cloud SQL supports complex queries and ACID transactions, but this means the database acts as a ‘fixed pipe’ and performance is less scalable. Many applications use both types of storage.
--
Joe Faith | Product Manager | Google Cloud

Alfred Fuller

unread,
Nov 14, 2012, 6:32:37 PM11/14/12
to google-cloud...@googlegroups.com
(the also datasstore provides ACID transactions)

This IO talk might also help: http://www.youtube.com/watch?v=rRoy6I4gKWU
(and I'm only partly suggesting it because I was one of the presenters)

Reply all
Reply to author
Forward
0 new messages