hello! does anyone know if it's possible to bypass...
# help
b
hello! does anyone know if it's possible to bypass the max rows setting? we would like to keep the value low generally, but have a special case where we need to query all rows from a table in a serverless function, and we are hitting time limits due to the pagination, so are looking for a way to dump a table essentially
n
Hello @brandymarsh! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.
g
The setting applies to all returns. You can use range and multiple queries. You might be able to put all the table in a single json object and return that but I've not actually done it.
n
relian (2022-05-05)
b
alright, thanks for the response!
g
@brandymarsh I did a quick test and returning one large json array gets around the row count.