Andrew Green wrote: <snip>
Frankly, if you're not sure of an upper limit to the size of data youThis won't help if the database is running on a different machine. If the apache and mysql are on the same machine, this will work although there are security concerns regarding this. This isn't a good solution if you _ever_ plan to scale up and move the database to another machine.
might need to try to write to the database, sooner or later you're bound to have to try to send something too big. I'd really suggest looking into the Storable or FreezeThaw CPAN modules as a way of just dumping (the big bit of) your data to disk, referencing that file from the MySQL database and remembering to delete the file if you need to delete the database record.
The best thing to do is to study your use cases and find the right value for max packet size, and also to prohibit the insertion of anything bigger at the application level.
Peace, Jamie
-- Report problems: http://perl.apache.org/bugs/ Mail list info: http://perl.apache.org/maillist/modperl.html List etiquette: http://perl.apache.org/maillist/email-etiquette.html
