Re: BLOB

> 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