crystalized
Programmer
I see a lot of posts here and on the SQL Server site talking about having images stored in your file system rather than in your database.
I have not had to handle images yet (mostly because I am putting them off until last). But my application will involve users submitting images.
I would like to know why everyone seems so adverse to storing the images within the database. In SQL Server 7.0 I believe there are a couple of datatypes designed to store things like images. So I am unsure of what the problems are with storing the images directly in the database.
If anyone can shed some light on this issue for me, or point me in the direction of some good articles I would appreciate it. [sig]<p>Crystal<br><a href=mailto:crystals@genesis.sk.ca>crystals@genesis.sk.ca</a><br><a href= > </a><br>--------------------------------------------------<br>
Experience is one thing you can't get for nothing.<br>
-Oscar Wilde<br>
[/sig]
I have not had to handle images yet (mostly because I am putting them off until last). But my application will involve users submitting images.
I would like to know why everyone seems so adverse to storing the images within the database. In SQL Server 7.0 I believe there are a couple of datatypes designed to store things like images. So I am unsure of what the problems are with storing the images directly in the database.
If anyone can shed some light on this issue for me, or point me in the direction of some good articles I would appreciate it. [sig]<p>Crystal<br><a href=mailto:crystals@genesis.sk.ca>crystals@genesis.sk.ca</a><br><a href= > </a><br>--------------------------------------------------<br>
Experience is one thing you can't get for nothing.<br>
-Oscar Wilde<br>
[/sig]