Re: [PHP] Re: how to display images stored in DB

Kevin Waterson wrote:

This one time, at band camp, zerof <zerof@xxxxxxxxxxxx> wrote:

It is not a good practice to store pictures in DataBases, use links,
instead of.

Rubbish, where are your benchmarks?

It has almost nothing to do with benchmarks.

Images are typically best supported in the form of files. They are more
easily manipulated by external tools.

The web browser sees an image as a single HTTP request. Invoking the PHP
script engine, parsing the script, and executing a SQL query to retrieve
the image from the database is less efficient than letting the web server
just send the file.

Image files do not need to be constrained by the rigid requirements of a
relational database.

I could go on, but it should be clear enough that putting images in a
database is not a good idea.
.

Relevant Pages

  • Re: [PHP] Re: how to display images stored in DB
    ... It has almost nothing to do with benchmarks. ... the image from the database is less efficient than letting the web server ... I'd keep it in a database, then when I need it cache a local copy on the ... scalable system for accessing system services | ...
    (php.general)
  • Re: Performance benchmarks
    ... Just remember the old saying, "Statistics don't lie, but liars do ... data usage patterns) and perform your own benchmarks. ... other factors that go into determining "which database is best," but I'm ... Microsoft MVP - Windows SDK ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Performance benchmarks
    ... Just remember the old saying, "Statistics don't lie, but liars do ... data usage patterns) and perform your own benchmarks. ... other factors that go into determining "which database is best," but I'm ... Microsoft MVP - Windows SDK ...
    (microsoft.public.sqlserver.server)
  • Re: Performance benchmarks
    ... Just remember the old saying, "Statistics don't lie, but liars do ... data usage patterns) and perform your own benchmarks. ... other factors that go into determining "which database is best," but I'm ... Microsoft MVP - Windows SDK ...
    (microsoft.public.sqlserver.programming)
  • Re: Performance benchmarks
    ... Just remember the old saying, "Statistics don't lie, but liars do ... data usage patterns) and perform your own benchmarks. ... other factors that go into determining "which database is best," but I'm ... Microsoft MVP - Windows SDK ...
    (microsoft.public.sqlserver.setup)