• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: imeges in database... a suggestion
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: imeges in database... a suggestion


  • Subject: Re: imeges in database... a suggestion
  • From: Dev WO <email@hidden>
  • Date: Fri, 9 Dec 2005 13:05:31 +0100

Hi Amedeo,
I'm not experienced enough, but as far as I've seen on this list and other, I think people are using both.
I know at least one person who didn't see any performance hit using images in database (1).


But personally I go for #2.
at least if there are any limitation on the database side (like number of request per second), as the file are served by the Web Server and not the database you won't get trouble.
I think there's also a memory footprint quite smaller with #2 as the image won't be in the snapshot but only a short string.
I also think if the user of the website reload the page or a page with the same image, I'm not sure the browser will behave the way it should and use the one it already have in cache if it is served by the WO application and not the Web server...
One last thing that "relaxes" me is the fact I don't have to think "am I going to have problem with image caches" as the image isn't in the snapshot;)


But as I said at the beginning, I'm sure people will come up with valuable insight about storing to the database (like portability):)

So this was just my 2 cents

Xavier



Hello, I have a products database...

Products contains images...

what is better...?

1) insert images directly into database as BLOB / NSData

2) upload (automatically) file in a directory and store into database only the file reference? (I do this actually)


Best regards.
Amedeo
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40anazys.com


This email sent to email@hidden


_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden
References: 
 >imeges in database... a suggestion (From: Amedeo Mantica <email@hidden>)

  • Prev by Date: imeges in database... a suggestion
  • Next by Date: Flash XML help
  • Previous by thread: imeges in database... a suggestion
  • Next by thread: Flash XML help
  • Index(es):
    • Date
    • Thread