'Datasette - Changing SQL query time limits, code not running

I set up my first Datasette database, got everything up and running but the data is large (millions of rows). The SQL inquiries timeout after one second, but there's an easy fix, so I ran the code in my terminal (using a Mac).

The example code is:

datasette mydatabase.db --setting sql_time_limit_ms 3500

I ran that, substituting my database name and a 5000 for the time limit. It started running, and I got this:

INFO:     Started server process [28725]
INFO:     Waiting for application startup.
INFO:     Application startup complete.
INFO:     Uvicorn running on http://127.0.0.1:8001 (Press CTRL+C to quit)
^CINFO:     Shutting down
INFO:     Waiting for application shutdown.
INFO:     Application shutdown complete.
INFO:     Finished server process [28725]

I shut it down using CTRL+C after 15 hours of it running without resolving (at ^CINFO), the database still has a 1 second query limit. I tried running the code a few times previously as well. Never got any error codes, but it never resolved either. New to Datasette and this kind of coding, so any advice on why the command isn't running would be appreciated.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source