Re: binary data (php/mysql) - comments wanted

From: 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

« previous php.general (#27050) next »