jack schitt
New member
I'm building a website which will allow people to upload images (among other things). Originally, I was planning on storing images uploaded by a user in a /images folder with the filename=the db key for the image. I'm not sure that the host I'm planning on using allows write access to the page's folder by the page that will handle the uploading.
MS Sql has a varbinary datatype that I could use to store the binary contents of the image (assuming the image passes validation etc).
My question is, in terms of speed and reliability, which is better for me to do: find a host that allows write access to asp.net pages or store the images in a varbinary(MAX) field in the database?
The reason I'm even bothering with this question is the most hosts don't advertise whether or not they allow asp.net pages write access to folders under their execution folder and I'd rather not call 20+ hosts to ask this question.
Also, what are some downsides to consider with either method?
This is my first production-level asp.net project so any additional tips relating to upload are also requested.
MS Sql has a varbinary datatype that I could use to store the binary contents of the image (assuming the image passes validation etc).
My question is, in terms of speed and reliability, which is better for me to do: find a host that allows write access to asp.net pages or store the images in a varbinary(MAX) field in the database?
The reason I'm even bothering with this question is the most hosts don't advertise whether or not they allow asp.net pages write access to folders under their execution folder and I'd rather not call 20+ hosts to ask this question.
Also, what are some downsides to consider with either method?
This is my first production-level asp.net project so any additional tips relating to upload are also requested.