saving big attachements in a server folder istead of database, v1.0 rc1

Submitted by cniitei on 2011-12-15

Once again, Hi

We experienced problems with adding an attachment of a higher weight then the specified size, i.e. saving a big file to a folder on the server rather then in a database. The program was saying something like "internal error". We checked all the file size restrictions on the client, and i think we also checked the file size restrictions on the server side as well. Everything seams to be right.

We ended up setting the limit of 255 mb, so that even such big files are kept in the DB. But my collegue says that it's not a good idea to keep that big files there.

Thanks in advance,
Andrey

Storing big attachments in database is generally not a good idea, because there are limits of the size of SQL queries, memory available to PHP, etc. Also make sure you configure the maximum post size and processing time in PHP configuration and web server configuration. The WebIssues Manual links to http://php.net/manual/en/features.file-upload.common-pitfalls.php, which explains some of the problems.

Regards,
Michał