To ensure stable performance and efficient resource usage, Bytebase allows you to configure execution limits for SQL queries in the workspace.

How to Configure

In the workspace, go to Settings > General, then scroll to the Security section. You can set the following limits:

Maximum SQL Result Size

Sets the maximum size of query results returned in the SQL Editor.

  • Unit: MB
  • Helps prevent memory issues caused by large result sets.
  • Example: 100 MB

Maximum SQL Result Rows

Limits the number of rows returned by a single query.

  • A value of 0 or below means no row limit.
  • Helps avoid performance degradation due to excessive row counts.
  • Example: 1 row

Maximum Query Time

Defines the maximum time (in seconds) a SQL query is allowed to run.

  • A value of 0 means no time limit.
  • Queries exceeding this time will be automatically terminated.
  • Example: 60 seconds