Tag Info

Hot answers tagged

10

BigTable doesn't use SQL (a query language) so SQL can't be used directly to query the database. And BigTable doesn't have "relations" in the same way as relational databases, it's more like bare tables. If you want to get data from two tables, you have to do two lookups, and combine the result set in the application code. In other words the "join" ...


3

There probably is a performance difference, but it's probably pretty small. Here's what I found (all based on the the Google Docs for Python). BigTable does not support PolyModel information natively. Instead, it's implemented using a 'class' property. So, when you try to perform a search, for example, to find a base class, you will be searching on this ...


1

Partitioning a table will help you in maintaining. Here are some useful articles on maintaining a large table: Handling Large SQL Server Tables with Data Partitioning The only downside is that it only exists in the Enterprise and Developer editions. Simplify Database Maintenance with Table Partitions And more info on hardware, horizontal, and vertical ...



Only top voted, non community-wiki answers of a minimum length are eligible