Attachment field size considerations
When setting the Max Size property for an attachment field, set a size that is large enough to accommodate typical attachments but small enough to conserve database space. If the size of an attachment exceeds the attachment field's allocated space, users cannot add an attachment to it even when the attachment pool contains other empty attachment fields.
Attachment size can also be limited by the available memory on the client computer. For example, your database might allow attachments up to 2 GB but be limited to attachments of only a few MB because of client memory constraints.
To set maximum attachment sizes for Oracle (including memory allocation), Microsoft SQL Server, and Sybase databases, see Db-Max-Text-Size.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*