Hey. I just wanted to know what the best way of storing images is- scores of
quite large jpegs. Are there any best practices I should know about?
Thanks
Cheers
Justin DutoitMachealth wrote:
> Hey. I just wanted to know what the best way of storing images is-
> scores of quite large jpegs. Are there any best practices I should
> know about?
> Thanks
> Cheers
> Justin Dutoit
Many advocate storing the images on disk and just storing a pointer to
the file in the SQL Server database. If you _must_ store in the
database, then you may want to place the table or just the image column
from the table on it's own filegroup (on a different set of drives).
David Gugick
Imceda Software
www.imceda.com|||Justin,
It all depends on the system and what the JPEG mean within the system. If
the file is an attribute of the data, then I advocate storing it in the
database.
The downside to storing files on disk with a pointer in the database:
> No referential integrity
> Filenames must be unique (this means you need to rename files as they
come in to something like 24_OriginalFileName.jpg where 24 is your Pointer ID)d">
> Portability & Backup Headaches
> Write file permissions required on special folder
But as David said, if your images are expected to be quite large, use a
different filestore for the table.
-- Alex Papadimoulis
"Machealth" wrote:
> Hey. I just wanted to know what the best way of storing images is- scores
of
> quite large jpegs. Are there any best practices I should know about?
> Thanks
> Cheers
> Justin Dutoit
>
>|||www.aspfaq.com/show.asp?id=2149
