4 ms·
> PRAGMA busy_timeout = 5000; I would go higher than this by default. Probably the best default is something like "amount of time a human would be willing to w
by jmull 2y ago
> PRAGMA busy_timeout = 5000;
I would go higher than this by default. Probably the best default is something like "amount of time a human would be willing to wait for something they want before giving up" which, if you have to pick one value, is hopefully longer than 5 sec. Perhaps 30000.
Now, there are also cases where fail-fast is best. However 5000 isn't good for those either. And that assumes a wider system that handles failures in quite a nice way, which doesn't happen without special effort, so doesn't make sense to target with a default value.