Microsoft SQL Server
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsDatabaseMicrosoft SQL Server

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old January 23rd, 2004, 11:01 AM
haffej haffej is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Jan 2004
Posts: 87 haffej User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 5
uploading images

i have a question about the general practice of having users upload images. in what cases is it better to store uploaded images in a database, and in what cases is it better to store images in a directory? i know that retrieving images is slower when they are stored in a database, but it seems easier to manage images when they're in a database (partly because i don't have to worry about file names or paths).

i ask because in trying to redesign a site, there is a gallery which i initially had uploading images to a database, but now that there are about 40 images stored, retrieval to a thumbnail layout is slow and sequential since it is cycling through the recordset. so i'm wondering, then, whether it's EVER a good idea to store images in a database?? for instance, our members are permitted to upload one personal picture for their profile, and it's only viewed in the user's profile (so only one image would be accessed at a time)... is this a good scenario for database storage over directory storage?

Reply With Quote
  #2  
Old January 23rd, 2004, 12:42 PM
Memnoch's Avatar
Memnoch Memnoch is offline
Unholy Moderator
Click here for more information.
 
Join Date: Oct 2003
Location: In hell, where did you think?
Posts: 11,781 Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level) 
Time spent in forums: 3 Weeks 5 Days 8 h 45 m 55 sec
Reputation Power: 470
It is always better to store the images in a directory, and store the path to the image in the database.

Reply With Quote
  #3  
Old February 3rd, 2005, 03:05 PM
jobo jobo is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Oct 2004
Posts: 141 jobo User rank is Corporal (100 - 500 Reputation Level)jobo User rank is Corporal (100 - 500 Reputation Level)jobo User rank is Corporal (100 - 500 Reputation Level)jobo User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 23 h 11 m 14 sec
Reputation Power: 6
Exclamation uploading images

Not that this is my situation, but if one had a web farm, i.e., multiple servers. Wouldn't the database make more sense than deploying the .gif directory to multiple machines? Even more so if customers were able toupload their images?

Or to put it backwards, when does the DB make more sense to store gifs?

Reply With Quote
Reply

Viewing: ASP Free ForumsDatabaseMicrosoft SQL Server > uploading images


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway
Stay green...Green IT