sql_time_limit_ms for deployment to Google Cloud Run

[adelaide01]

Hi Simon and everyone,
I was able to deploy to Google Cloud Run, but I need to increase the default sql_time_limit_ms to 11000. I have a database with 3.6 million rows and that is how long it took to return a large query on my computer (before I deployed).

https://docs.datasette.io/en/stable/settings.html?highlight=time%20limit#sql-time-limit-ms

Is there a way to change the default sql_time_limit_ms in the Python source files? I searched under sql_time_limit_ms https://github.com/simonw/datasette/search?q=sql_time_limit_ms but it is not clear which Python file to change.

Thank you in advance!

[adelaide01]

My solution was to change the default sql_time_limit_ms in the app.py file.

You can look at the settings in the app.py file here:
https://github.com/simonw/datasette/blob/2883098770fc66e50183b2b231edbde20848d4d6/datasette/app.py

On the Mac OSX, app.py is located in this directory:
/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/site-packages/datasette

I re-deployed to Google Cloud Run and everything is working well. Thanks for Datasette! I am excited about the possibilities.