How to run test database in Django?

Are there any database benchmarks suitable for assessing performance on constrained hardware (eg laptops)?

• Most times I see performance benchmarks for a database, it's TPC or similar and the test is done on a massive server with as many CPUs as the company could jam in there, as if microchips grew on trees and cost was no object.  Great if you're building the World's Biggest Transactional Database, but not so illuminating if you're trying to figure out what's best for a problem when you have very constrained hardware. For example, I want a SQL-based interface to deal with circa 50 million rows of data, and I want to be able to carry that with me when I fly from Singapore to the US, *and* I'm flying economy class, not in Tony Stark's jet with a bank of servers in the galley.   Are there useful performance benchmarks for a database being run on (eg) a laptop with 4Gb of ram doing analytical work?

• Answer:

  You are right, as far as I know there are no such benchmarks. But you can flip the coin and take TPC-H like bechmarks with small data sets and run them on your laptop. Or just take a look at the following  https://launchpad.net/test-db to benchmark your database, or to the more generic http://www.mysqlperformanceblog.com/2011/02/01/sample-datasets-for-benchmarking-and-testing/, where you may find both datasets and test queries sometimes. In any case, regarding Graph Databases, the http://ldbc.eu will set benchmarks and might probably take this specific case as one of the issues to push benchmarks for.