On Sun, Oct 10, 2021 at 6:17 PM [email protected] <[email protected]> wrote:
> I like the default pool_timeout of 5 seconds, but sometimes I'd like to > extend it like for example when I'm uploading photos in a transaction and I > want everything to fail if one of the items doesn't copy to a AWS bucket. > > Probably not a good practice to open a transaction and put web requests > running inside, but if I want to increase the pool_timeout for one block, > how can I do that? > > ie. > > db.transaction do > > end > > something like... > > db.transaction(pool_timeout: 20) do > > end > > Something like that exists? > No. The pool timeout is fixed. I'm not sure it would help your case anyway, since the pool timeout is the amount of time before a request to checkout a connection from the pool raises an exception. It doesn't affect how long a connection is allowed to be checked out. Trying to increase the pool timeout is unlikely to be a good solution. Increasing the number of connections the pool is probably a better approach to solving the problem. Thanks, Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/sequel-talk/CADGZSSdAeFEthXAsxfCVKt-yiMJLk8rJKLmDxWHX2gUMDuPb4g%40mail.gmail.com.
