5 ms·
Why can't you just create a pool of databases and truncate all tables after each run ? That should be pretty fast
by ritz_labringue 2y ago
Why can't you just create a pool of databases and truncate all tables after each run ? That should be pretty fast
- williamdclt 2y agoDELETE is faster on a small amount of data. But yea, DELETEing is faster than creating a DB from template (depends on how much you have to delete, of course). However, templates allow parallelism by giving its test its own database. I ended up doing a mix of both: create a DB if there's not one available, or reuse one if available, always tearing down data.
- eddd-ddde 2y agoTRUNCATE is faster than DELETE. You could have 100 dbs, each test first acquires one, runs, truncates, releases. No need to create more dbs on the fly.