Last post Oct 08, 2006 12:04 AM by rhhanson63
Sep 14, 2006 09:33 PM|akent|LINK
Sep 15, 2006 09:30 AM|rhhanson63|LINK
I am looking at that also. Actually, I am looking at converting a "live" site from DB to file system, so any insight would be benificial.
Sep 16, 2006 12:54 AM|akent|LINK
What do you mean? That you are currently storing photos in a DB and now want to retrive them and store them in an upload type directory on the filesystem, is that what you mean??
Sep 16, 2006 12:57 PM|whighfield|LINK
If your site is going to be running under a server farm I would guess (possibly) that you would have some sort of file server that is shared amongst the load balanced web servers. This would allow you to have
a central store for images being accessed via a virtual directory on each web server. If not then the SQL option may be the best option as you would not be forced to create an admin tool that would copy files to all web servers or at least create a virtual
folder on each web server that points to one instance of a web server, this somewhat defeats the purpose of the load balancing.
The file system would be preferred (my opinion) and all you would have to to do is modify the handler.aspx and the admin side of things to support the file system method (for the PWSK).
Sep 17, 2006 01:15 AM|rhhanson63|LINK
Tha tis correct. I am using the PSK for a photography friend of mine and the DB size is limited but I have more file storage space. The volume of photographs grew greater than expected. Anyway, I am looking at converting to the file system format. I
guess worst case is that I have the site owner reload all of the albums. I am looking at using the gallery function as well to help manage the albums more
Sep 18, 2006 11:43 AM|chapran|LINK
I'm a beginner and have not enough knowledge to modify handler.ashx in order to switch to file from database storage of images. My site
http://www.srssite.com is terribly slow after I added 13 images.
I'm asking for the code (C#) to make that swith
Sep 18, 2006 12:17 PM|jwadsworth|LINK
Sep 18, 2006 01:51 PM|chapran|LINK
Yes, it's not my host.
I played with 2 databases located on different servers. When I just changed connection string to the new database on the second server and there were no images in the database, everything was very fast. When I added 1 image I noticed the lower speed. When
I added more and more images, I've got unacceptable speed.
On the first server I just did not add images one by one, so I was not sure that this is the problem related to the size and number of images.
I downloaded your kit. It's in VB, I'm trying to convert handler.ashx to C#. I will test it after I'm done.
Thank you for your great KIT. Although it's not in C#, it's very helpful
Sep 19, 2006 10:57 AM|rhhanson63|LINK
I am beginning the work on cenverting from DB to File System for my my site (www.click-images.com) and was wondering if you could provide some insight into the potential issues. I am going to be using your site
as a base for the upgrade. I likek the Gallery feature as well as a few others. My biggest concern is getting the images out of the DB and into a file system. The obvious answer is to delete and reload, but that takes time. DO you have any suggestions?
Sep 19, 2006 11:33 AM|jwadsworth|LINK
I would say the easiest way is going to be to reload the images. The process is really pretty easy.
You have 7 albums. You just need to upload all the photos for one album at a time, to the Upload folder, and then use the Import All Images feature to fill your album. The crappy part is that you can only specify a generic description to be given to all
the photos being uploaded. It does not number them in the description. You could however, add a count in the loop where it creates each image.
Sep 19, 2006 02:14 PM|rhhanson63|LINK
Sounds good. That is exactly wht I was thinking, with the exception of the count, but it should all work well. Thanks for the quick response! I'll let you know when it is complete.
Oct 05, 2006 05:04 PM|rc51racer|LINK
Storing files on disk is much faster than streaming them from the database.
It also makes for easier backup and you can edit your files without having to make any database changes.
I have code that stores both images and video on disk here:
Oct 08, 2006 12:04 AM|rhhanson63|LINK
Thanks for everyone's assistance. Actually ended up filling the DB on GO Daddy before I got everything tested, but was able to make the mods and relaod the tables, stored procedures and used Jeremy's kit as a base for the site. I still have a few issues
to work out, but the site is up and running using the file system instead of the DB. I am going to take a look at
rc51racer's video storage next.