I am trying to create a sql query that can upload data into my tables from an excel sheet. I am fine with small amounts of data (eg 100 rows), but when I do bulk uploads (eg 1000 rows) I receive errors and then the smaller uploads stop working for a short period of time. Any idea why uploads stop working after I receive a timeout error? First image is the timeout error, second is when I try a smaller upload again
Hey @charliedarby
I'm curious if this is a matter of the query timing out in Retool while it's still running in your DB. If you get the timeout error have you tried waiting to see if the smaller queries start working again after a longer period without doing anything else?