Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002

    Unanswered: opinions requested

    I'm interested in anyones opinion on storing images in mysql directly as blob types vs. as pathnames to files stored in the servers filespace.

    My aim here is for speed. I can envisage the db having a few thousand records for unique images, stored over about 4 tables. Users will be able to search for images whose attributes match various inputs and in return they can expect to recieve the images that match these criteria.

  2. #2
    Join Date
    Sep 2002
    i would go for storing pathnames, it would be much easier to expand and to split data over harddrives.. it's easy to make links to 10 different drives but i dont like the idea of splitting the table into 10 pieces over 10 drives..

  3. #3
    Join Date
    Jul 2002
    Querying images? You don't work for Autonomy do you?

    I concur. Pathnames every time (even though I use blobs in some of my dbs). You're putting the load on the web server (to return the image) rather than the database and the web server (query, then return) that way. Faster.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts