data-api-builder icon indicating copy to clipboard operation
data-api-builder copied to clipboard

Config property: Customize transaction timeout (seconds)

Open severussundar opened this issue 2 years ago • 3 comments

Make the timeout period of the transaction (associated with a graphQL mutation or REST Post, Put, Patch and Delete request) configurable through the CLI. This is proposed to make sure that resources acquired by a single transaction do not become unavailable to other transactions thereby starving them.

severussundar avatar May 10 '23 11:05 severussundar

Hey, would be great to have the option to customize this. (Changing the timeout in the connection string does nothing).

We currently aim to allow users to bulk-insert data by uploading CSV files. A real example from a client has around 3,000 items in the CSV file, from which our stored procedure creates each item, as well as creating multiple parameter items for each item created (ending in 3000 items, as well as over 50,000 parameters referenced by said items). Its very possible that this example could grow over time also. We are on a low powered SQL database in Azure currently, and can of course boost this, but could see this being a problem in the future regardless.

Any update on this would be great!

pingu2k4 avatar Jul 23 '24 11:07 pingu2k4

Hey, would be great to have the option to customize this. (Changing the timeout in the connection string does nothing).

Connection string does nothing?

JerryNixon avatar Aug 31 '24 00:08 JerryNixon

Yes, changing the timeout specified in the connection string to something larger than 30 seconds isn't respected, and there doesn't appear to be any config allowing modification of any sort of override

pingu2k4 avatar Aug 31 '24 08:08 pingu2k4