Re: BLOB

Okay so what you are saying is that I would be better off creating the path to images and store that data in the database.? I'll take your word for it and avoid the database storage option. Ta for your help. Karl Daniel Beulshausen wrote: > > Is there anyone out there who knows how to get Images into a mySQL > > database? > > I have the Images in a folder on the web server and have them locally, > > anyway of shifting them into my BLOB field would be handy. > > > > Succumbed to severe retinal burns following mass exposure to my monitor > > trying to solve this. > > . > > Any help gratefully received. > > actually inserting images (binary data) into databases doens't make any > sense. > the only advantage is that you'd avoid broken links. but let's look at the > disadvantages. > if you store html in a database this is no problem, cause it is fetched in > one run, but if you store images, a script must be started to get the binary > data from the db. > that are n*2 loads, cause you start first php and then fire up the database. > if you use images stored in the filesystem, there won't by any such > redundant processes. > many database are extrem inefficient if they have to fetch blob's in > diffrent sizes, i.e. if some entries in the same table are very tiny and > some are verly large. > mysql's sendbuffer for binary large objects isn't very effecitve. > > so make your own decision, but imo it doesn't pay out, in large sites you'll > quickly ran into speed and memory problems. > > greetings > daniel > > /*-- > daniel beulshausen - daniel@php4win.de > using php on windows? http://www.php4win.de > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net