Click here to Skip to main content
15,867,141 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Good day to all!

I have a project in school that I have been working on, and I just want to ask if what is the best way to store more or less 20 thousand thumbnail of images?

The project is an Integrated Library System, with 20 thousand resources, and I'm looking for the best way to store and retrieve them in a fast and a efficient manner.
Posted
Updated 23-Jan-12 22:12pm
v2
Comments
unknowndentified10111 24-Jan-12 4:00am    
Store in where? Hard disk? And is this a Web Application? Please specify more details.
phianasol 24-Jan-12 4:05am    
Its a Windows Form Application sir. I'm looking for the best way to store images.
Manoj Kumar Choubey 24-Jan-12 4:02am    
Application path ....

I never worked with that much of images. Looks like a nice project.

Links
Save & Read Image From Database[^]
Uploading and Storing Image Path to Database and Image to Folder[^]

Yep these links are for web application but you need only some changes to migration(Win app).
But I prefer file-system to store/retrieve images by saving only file path in database. Also read these

Discussions
Should I store images in the database or the filesystem?[^]
Storing Binary Files Directly in the Database Using ASP.NET 2.0[^]

Now you decide. Best wishes for your project :thumbsup:
 
Share this answer
 
Comments
phianasol 24-Jan-12 4:35am    
Thank you Sir for your assistance! I'll definitely look into the discussions and links.
koolprasad2003 24-Jan-12 6:00am    
Nice links Raja,+5
Amir Mahfoozi 26-Jan-12 3:06am    
+5
1. Programatically create a folder and store images with unique name or id. ,
2. Create a dynamic path of this image and store it to database table.
 
Share this answer
 
Comments
phianasol 24-Jan-12 4:03am    
Thank you Sir for answering my question! I'll give this a try. :)
Hi,

if you can use db, you can save images into db. But It would be great if you tell us more information about your project.


Regards
Robert
 
Share this answer
 
Comments
phianasol 24-Jan-12 4:19am    
The project is an Integrated Library System, with 20 thousand resources, and I'm looking for the best way to store and retrieve them in a fast and a efficient manner.
You can use a database to save the thumbnails as Kanasz Robert answered. In MSSQL use the varbinary(max) datatype, in MySQL use the blob data type.

Storing images in the database might be better when you only store thumbnails with a very small file size, since the risk of loosing the thumbnail file is removed, however, it might affect the performance of your query when you are querying a table with an image data type.
 
Share this answer
 
Comments
phianasol 24-Jan-12 4:31am    
Thank you Sir for answering my question! I'll give this a try. :)
 
Share this answer
 
Comments
phianasol 24-Jan-12 4:31am    
Thank you Sir for answering my question! I'll give this a try. :)
create one image folder in your project.. and save that image path in db. retrive the data from database with imagepath, and display image.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900