How do I set a query row or time limit on a connection?

Every connection has built-in caps that stop one query from overloading the database or returning too much data. You set them when you add or edit the connection. You need the Manage data sources capability.

1. Open Admin, then Connections.
2. Click the connection you want to change, or click New connection to make a new one.
3. Set the three limit fields:
   • Statement timeout is the longest a query may run, in milliseconds. The default is 30000, which is 30 seconds.
   • Row limit is the most rows one run may return. The default is 1000.
   • Result size is the largest result Squeezle will hold, in megabytes. The default is 10.
4. Change any of the three to fit your database.
5. Click Save.

These caps apply to every query run against this connection, so no one can get around them. A person's own limits can only make these tighter, never looser.

For the full walkthrough, see the Connections guide.