5 ms·
> tracking the table ... isn't reliable without [trigger] or [orm] We use sequences, which is neither of those, and has been very reliable for us. I included
by stephen 2mo ago
> tracking the table ... isn't reliable without [trigger] or [orm]
We use sequences, which is neither of those, and has been very reliable for us.
I included the disclaimer that you need a schema that follows strict sequence name => table name conventions, but that's what we have.
> 20% of runtime creating users
Right -- we also have ~2-3 "stable" rows of users that every test needs, so we can skip re-creating for each test.
- ltbarcly3 2mo agoUsing sequences is clever if you always increment a sequence for every insert, but again my analysis says that unless your table clearing is much slower than mine it's hardly worth it to check, in fact checking the value of every sequence can't take much less than 5ms which is how long it takes to clear every table if empty but is less general.