3 ms·
I have seen it done in a small company to check if a query will run too slow in production. Take a copy of the biggest database. Run query, see what happens, de
by baroffoos 8y ago
I have seen it done in a small company to check if a query will run too slow in production. Take a copy of the biggest database. Run query, see what happens, delete copy.
- fooey 8y agoIt's probably more often that the query is just run against production in the first place. Making a copy is probably more effort than most developers out in the wild are going to make.
- sroussey 8y agoNot true. If you were to throw up a slow locking query in production, you could take down the site. Restoring a backup should be fast.