This page last changed on Aug 09, 2010 by rosie@atlassian.com.

Limitations on project totals imposed by databases:

Database Limitation
Oracle 1000
SQL Server No hard limit as a query can have any number of parameters, as long as it remains within the maximum batch size — which defaults to 65,536 * Network Packet Size (256MB). In practice, however, 2100 is the limit as this is the maximum number of parameters allowed by SQL Server.
MySQL No hard limit; maximum query size has to be less than max_allowed_packet, which defaults to 1GB, but can be any value in the range 1024-1073741824 Bytes.
PostgreSQL No hard limits; SQL query size is limited to the OS maximum file size.
HSQLDB No limits specified, but in practice limited by heap memory.
Document generated by Confluence on Mar 27, 2011 18:52