Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Why can't you just create a pool of databases and truncate all tables after each run ? That should be pretty fast


DELETE 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.


TRUNCATE 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.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: