aleitner commented on PR #821: URL: https://github.com/apache/guacamole-client/pull/821#issuecomment-1499291861
@mike-jumper PostgreSQL: Suggested batch size: 5000 Rationale: While PostgreSQL does not have a specific limit on the number of parameters per query, the maximum number of parameters per prepared statement is 65535. Choosing a smaller value than the maximum limit can help avoid potential performance issues or query execution errors. Relevant documentation: https://www.postgresql.org/docs/current/runtime-config-resource.html#GUC-MAX-PREPARED-STATEMENT-ARGS MySQL and MariaDB: Suggested batch size: 1000 Rationale: MySQL and MariaDB impose a limit on the maximum size of a query, determined by the max_allowed_packet configuration variable. This value is typically much larger than the actual number of parameters used in a single query. A smaller batch size like 1000 is often used in practice to accommodate the max_allowed_packet limit without exceeding it. Relevant documentation: MySQL: https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_max_allowed_packet MariaDB: https://mariadb.com/kb/en/server-system-variables/#max_allowed_packet SQL Server: Suggested batch size: 2000 Rationale: SQL Server supports a maximum of 2100 parameters per query, as mentioned in the error message you provided. To stay within this limit, you can set the batch size to a smaller value like 2000. Relevant documentation: https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server Keep in mind these are all just suggestions as there isn't an actual limit for mysql and postgres -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@guacamole.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
