On Wednesday 21 November 2007 03:14:43 Ronald Wiplinger wrote: > I have an application, where I use pictures. The size of the picture is > about 90kB and to speed up the preview, I made a thumbnail of each > picture which is about 2.5 to 5kB. > I use now a directory structure of ../$a/$b/$c/<pictures> > > I wonder if it would be good to put the thumbnails into the current > table, in a different table or leave it like it is now. Same for the > pictures. > > What is your opinion and why? Ouch this particular piece of topic is a all time champion of things to discuss... Richard Lynch is pretty good at beating that old horse ;D (you there?) I would say it's up to you and the project... I've made a couple of pedigrees and membership lists where I've chosen to put images in the database for the reason of simplicity. 10.000 small images really gets me depressed when viewed as files. _I_ feel that a list of ... lets say 250 employees is far more compact and corrrect in a blob; small program and everything piled in one place. The previous mailer talked about huge blob data, mine will never come close 12gb of blob data. I've made a couple of forums where multiple image uploading and expanding possibilities made it awkward to use blobs. As I said, if youre comfortable with using files in a blob rather than remote filesystem, and the project works OK with it, why not. On the other hand, none've my tables passed 1gb yet. > > bye > > Ronald -- --- Børge Holen http://www.arivene.net -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
