When using Z SQL Methods on a ZMySQLDA Database Connection, don't add a LIMIT clause. ZMySQLDA does this for you, based on the max_rows property of the Z SQL Method. This makes ZMySQLDA much faster on large result sets. LIMIT is a non-standard MySQL extension, so you should avoid using it in queries anyway. But, if you really need a LIMIT clause, set the max_rows property of the Z SQL Method to zero, and ZMySQLDA won't add one. Alternatively, you can trick ZMySQLDA into leaving the limit out by putting a comment just before the SELECT statement.

Side note: Use <dtml-var sql_delimiter&rt; instead of semicolon (;) to separate multiple SQL statements in the same Z SQL Method.