Hello Mengü,
thanx for your reply. you might be right with the comparison to today
servers.
I am doinb both. Filesystem, like you explained and blobs. Filesystem on
larger
images and onece which are used more fequently. However I planed to move
those to blobs since I want to do dynamic quality. You say this can be done
by
GD. How? This is what my problem is. Thank you for any hint on that. This
what
gives me a headache. Currently performance is ok, so I have to take care to
get
the functionality.
Cheers,
merlin
----- Original Message -----
From: "Mengü Gülmen" <mengus@soursummitz.org>
To: "Merlin" <news.groups@web.de>
Sent: Wednesday, May 14, 2003 2:06 PM
Subject: Re: dynamic image quality from blobs?
> I don't know how you can say that the performance is great?!?
> It's simple logic: blob data holds a great amount of place in the
database,
> and of course on the disk.
> the blob data is not a filesystem entry, it must first be searched in the
> database then on the disk, then it must be transferred through the
> established connection (whatever it is, pipe or whatever) etc etc..
>
> keeping the path of the image (or better, using images renamed like
> row_id.jpg) and transferring some small bytes is always easier and faster
> than using blob data.
>
> if you want to put a watermark, you can simply do it on the image itself,
> and dynamic quality etc, can be achieved using GD everywhere :)
>
> Maybe today's standard servers handle these things easily and you feel no
> lack of performance, in high load, large scale applications whatever your
> server is, you will notice the difference.
> ----- Original Message -----
> From: "Merlin" <news.groups@web.de>
> To: "Dave Carrera" <dave@ephgroup.com>
> Cc: <php-db@lists.php.net>
> Sent: Wednesday, May 14, 2003 2:44 PM
> Subject: Re: dynamic image quality from blobs?
>
>
> > Hello Dave,
> >
> > I do not agree. Images in DB are a great thing. You can play around with
> > them, put watermarks or try to create a dynamic quality delivery for
each
> > user (like I am trying right now:-) Performance is great and it keeps
> things
> > way more easy!
> >
> > Cheers,
> >
> > Merlin
> >
> > PS: Has anybody an idea on how to create this dynamic quality image
> > delivery? All posts on this topic are not relevant to the problem;-((
> >
> >
> > ----- Original Message -----
> > From: "Dave Carrera" <dave@ephgroup.com>
> > To: "'Merlin'" <news.groups@web.de>
> > Cc: <php-db@lists.php.net>
> > Sent: Wednesday, May 14, 2003 9:03 AM
> > Subject: RE: dynamic image quality from blobs?
> >
> >
> > Why are you using blob fields for image storage?
> >
> > It is far better to upload / replicate the image into dirs.
> >
> > This dramatically reduces the size of the db and speed of delivery.
> >
> > As you are using GD2 try this as an alternative method for your delivery
> > method. I posted this solution a few days ago but here it is again.
> >
> > Prog flow:
> >
> > Form has FILE input field named "picture" to find local jpg image.
> > On submit original file is uploaded to ./big dir
> > Then a thumbnail of 100x70 pixels is created and placed into ./thumb dir
> All
> > files are named with a unique filename. Then path info only entered into
> > MySql db for recall later, I never wanted to load images to a db, bad
> > idea...
> >
> > --- Start ---
> > If(isset($_POST[picture]){
> > $bigdir = "./prodimg/big";
> > $tumbdir = "./prodimg/thumb";
> > $tw = 70;
> > $th = 100;
> > if(isset($_POST[addproduct])){
> > if(isset($_FILES[picture])){
> > $fileName = explode(".", $_FILES['picture']['name']);
> > $name = str_replace(' ', '_', $fileName[0]);
> >
> > $img_orig_size = getimagesize($_FILES['picture']['tmp_name']);
> > $img_orig_width = $img_orig_size[0];
> > $img_orig_height = $img_orig_size[1];
> >
> > $img_original = ImageCreateFromJpeg($_FILES['picture']['tmp_name']);
> > $image_stored = time() . "_$name.jpg";
> > ImageJPEG($img_original, ".$bigdir/$image_stored",100);
> >
> > $img_resized = ImageCreateTrueColor($tw, $th);
> >
> > imagecopyresampled($img_resized,
> > ImageCreateFromJpeg($_FILES['picture']['tmp_name']), 0 , 0 , 0 , 0, $tw,
> > $th, $img_orig_width, $img_orig_height); $img_name = "tn_$image_stored";
> >
> > Imagejpeg($img_resized, ".$tumbdir/$img_name",85);
> >
> > ImageDestroy($img_resized);
> >
> > $mysql_thumb = "$tumbdir/$img_name"; //thumbnail path to write to mysql
> > $mysql_big = "$bigdir/$image_stored"; // original path to write to mysql
> //
> > Do your own mysql_query here }
> > --- End ---
> >
> > You will need to 777 both the thumb and big dir. Also note the use of
> > "ImageCreateTrueColor". This is tons better than just using
"ImageCreate",
> > also note the 85. This sets the jpg compression. I found this value
gives
> a
> > good balance between visual quality and file size. $_POST[picture] comes
> > from an form with a field of this name. and remember to add the
> > ENCTYPE="multipart/form-data" to your form.
> >
> > Hope this helps
> >
> > Dave Carrera
> >
> > http://www.ephgroup.com
> > Secure Hosting Accounts for everyone.
> >
> > -----Original Message-----
> > From: Merlin [mailto:news.groups@web.de]
> > Sent: 14 May 2003 07:37
> > To: Maxim Maletsky
> > Cc: php-db@lists.php.net
> > Subject: Re: dynamic image quality from blobs?
> >
> >
> > I am using GD2 for this. However, does not work in this case?!
> >
> > Merlin
> >
> >
> > ----- Original Message -----
> > From: "Maxim Maletsky" <subscriptions@phpbeginner.com>
> > To: "Merlin" <news.groups@web.de>
> > Cc: <php-db@lists.php.net>
> > Sent: Tuesday, May 13, 2003 11:24 PM
> > Subject: Re: dynamic image quality from blobs?
> >
> >
> > >
> > > You should use GD2 for this. Check what you've got on your PHP's
> > > installation.
> > >
> > > Maxim Maletsky
> > > maxim@php.net
> > >
> > >
> > > On Tue, 13 May 2003 22:11:58 +0200
> > > "Merlin" <news.groups@web.de> wrote:
> > >
> > > > Hi there,
> > > >
> > > > I am trying to set a dynamic image quality. My images are stored as
> > blobs in
> > > > a mysql db. Till now the images are just echoed out to
> > > > the browser. This workes. Now I would like to add dynamic quality,
> > therefore
> > > > I tryed to output them with imagejpeg.
> > > > Unfortuanetelly this does not work at all, and I cant get behind the
> > > > problem.
> > > >
> > > > Has anybody a good idea?
> > > >
> > > > Thanx,
> > > >
> > > > Merlin
> > > >
> > > >
> >
>
############################################################################
> > > > ####################
> > > > # output
> > > > header("Content-type: $file_type");
> > > > echo $picture_blob;
> > > > // this would not work:
> > > > // imagejpeg($picture_blob,"",10);
> > > >
> >
>
############################################################################
> > > > ####################
> > > >
> > > >
> > > >
> > > >
> > > > --
> > > > PHP Database Mailing List (http://www.php.net/)
> > > > To unsubscribe, visit: http://www.php.net/unsub.php
> > > >
> > >
> > >
> > > --
> > > Maxim Maletsky
> > > maxim@php.net
> > >
> > >
> >
> >
> > ---
> > Incoming mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.478 / Virus Database: 275 - Release Date: 06/05/2003
> >
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.478 / Virus Database: 275 - Release Date: 06/05/2003
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
