Professional Web Applications Themes

Impact of Image files in database - Microsoft SQL / MS SQL Server

Dear Friends I am not able to take the decesion for adding the functionality to attache files in the database. please suggest if it will hamper the performance and what can be the pro and cons for the same. your guidence will help me to take the decesion. Best regards Niitmalad...

  1. #1

    Default Impact of Image files in database

    Dear Friends

    I am not able to take the decesion for adding the
    functionality to attache files in the database. please
    suggest if it will hamper the performance and what can be
    the pro and cons for the same.

    your guidence will help me to take the decesion.

    Best regards
    Niitmalad
    Niitmalad Guest

  2. #2

    Default Re: Impact of Image files in database

    Niitmalad,

    A frequent topic of discussion in the newsgroups.Do a search on the archives
    (http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
    ) for the keywords.

    --
    Dinesh.
    SQL Server FAQ at
    http://www.tkdinesh.com

    "Niitmalad" <co.in> wrote in message
    news:01c401c355ec$bc664e50$gbl... 


    Dinesh.T.K Guest

  3. #3

    Default Re: Impact of Image files in database

    Hi,

    Although the database does support blobs, its not a good idea to use them.
    Just store the meta-data of the images in the database.
    Databases are IMHO all about searching quickly for information .
    Storing data can be done just as well or even better on a plain filesystem.

    Good luck

    "Niitmalad" <co.in> wrote in message
    news:01c401c355ec$bc664e50$gbl... 


    Arjen Guest

Similar Threads

  1. Identifying image-only vs. image+text PDF files
    By Zamdrist in forum Adobe Acrobat SDK
    Replies: 6
    Last Post: December 16th, 08:25 PM
  2. Replies: 3
    Last Post: October 3rd, 07:54 AM
  3. Display Image from Database in an Image control
    By chrispragash@hotmail.com in forum ASP.NET Web Services
    Replies: 1
    Last Post: August 25th, 07:38 PM
  4. Storing and retrieving image files in a database
    By Duke Snyder in forum Coldfusion Database Access
    Replies: 3
    Last Post: March 30th, 02:53 PM
  5. Preserving links between Illustrator files and image files during system upgrade
    By M._Robert_Tyler@adobeforums.com in forum Adobe Illustrator Macintosh
    Replies: 2
    Last Post: June 5th, 02:27 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139