I am testing a db application. The best would be to create the database for every test. I timed the creation of a normal test database. This takes about two seconds. Currently I do not have many tests, so that would not be a problem. But when the number of tests would grow it could be. I expect that an in memory database would be a lot faster. But can I assume that an in memory database behaves the same as a normal database? Otherwise it would be not very useful. It is less important as I thought. When using transactions creating the database takes just a eight of a second.