Hi Gurudatta, I see your point.
Sincerely, Mike -- Mike Brandonisio * IT Planning & Support Tech One Illustration * Database Applications tel (630) 759-9283 * e-Commerce [EMAIL PROTECTED] * www.techoneillustration.com On May 24, 2007, at 3:14 AM, Gurudatta Raut wrote: > > Hi, > > I seriously doubt if image from stored in DB will be faster, since > u will have to > > 1) search it in Db > > 2) retrieve it from Db in memory > > 3) Save it by creating a new file > > 4) Create code to send this file to user > > 5) U will have to do this for each user every time > > 6) Hence it wont be in users cache > > Is that fast ? > > > > Mike Brandonisio <[EMAIL PROTECTED]> wrote: Hi Wade, > > Thanks for taking time to decipher my posting. Yes I figures that a > DB would be better than a flat file. All of the image will have meta > data to search on in the DB. The result will show a thumbnail and > link to the larger image. I read some where that windows folders on > FAT32 are something like 65,534 and on NTFS are 4,294,967,295 files > on a folder or folders in a folder. I cannot find anything on linux > though. Some say theoretical 10 to the 18 power. > > Sincerely, > Mike > -- > Mike Brandonisio * IT Planning & Support > Tech One Illustration * Database Applications > tel (630) 759-9283 * e-Commerce > [EMAIL PROTECTED] * www.techoneillustration.com > > > On May 23, 2007, at 7:23 AM, Wade Smart wrote: > >> 04232007 0716 GMT-6 DST >> >> A db is much faster than a flat file for searching. >> I dont know the whole deal with your client but, if they have a >> site for >> uploading images by a end user then Im guessing there needs to be >> some >> key words that go along with it like 72Porsche911T24.jpg - 1972, >> Porsche, 2.4 engine, T model, red color,..... something that a end >> user >> can search on. >> >> Ah, though if I reread your reply, you might be asking about the >> performance issue of a blob over a image in a folder and a path in >> the >> db. >> >> The db with a path name is faster - I would think. I dont have any >> other >> performance data on this but, just my own experience on creating this >> same thing, the path way is just text and that keeps your overall db >> size down low. That alone makes it faster. >> >> Wade >> >> On Tue, 2007-05-22 at 19:25 -0500, Mike Brandonisio wrote: >>> Hi Wade, >>> >>> Thanks. Have you heard of any performance issue with thousands of >>> images in one folder on linux vs. windows. There will be one admin. >>> This is strictly for searching for the stored images. >>> >>> Sincerely, >>> Mike >> >> >> >> Community email addresses: >> Post message: [email protected] >> Subscribe: [EMAIL PROTECTED] >> Unsubscribe: [EMAIL PROTECTED] >> List owner: [EMAIL PROTECTED] >> >> Shortcut URL to this page: >> http://groups.yahoo.com/group/php-list >> Yahoo! Groups Links >> >> >> > > > > Community email addresses: > Post message: [email protected] > Subscribe: [EMAIL PROTECTED] > Unsubscribe: [EMAIL PROTECTED] > List owner: [EMAIL PROTECTED] > > Shortcut URL to this page: > http://groups.yahoo.com/group/php-list > Yahoo! Groups Links > > > > > > > --------------------------------- > Download prohibited? No problem! CHAT from any browser, without > download. > > [Non-text portions of this message have been removed] > > > > Community email addresses: > Post message: [email protected] > Subscribe: [EMAIL PROTECTED] > Unsubscribe: [EMAIL PROTECTED] > List owner: [EMAIL PROTECTED] > > Shortcut URL to this page: > http://groups.yahoo.com/group/php-list > Yahoo! Groups Links > > >
