Re: binary data (php/mysql) - comments wanted
| From: | David Tod Sigafoos | Date: | Fri, 24 Nov 2000 21:53:13 +0000 |
| Subject: | Re: binary data (php/mysql) - comments wanted | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-27050@lists.php.net to get a copy of this message | ||
JR> I've got my script working with PHP 4 and storing binary data (JPGs and
JR> GIFs) in a mysql db for m,y personals program I'm writing. When all is said
JR> and done, I expect an average of 700-1000 pictures to in the db at any given
JR> time, with each picture averageing about 50KB. What, if any
JR> reliablity/preformance problems am I going to introduce witth using this
JR> amount of binary data in conjunction with mysql/php4? Would I be better off
JR> having my PHP script upload the file to a directory and then storing the
JR> link necessary to retrieve that file in the db and subsequently outputting
JR> that to the html page generated? Thanks for all your comments/suggestions.
I would suggest that you store the file pointer to graphics and not
the graphics themselves.
--
DSig
David Tod Sigafoos
mailto:dsig@teleport.com