troubleshooting Question

Storing a large number of images in the cloud system

Avatar of Mohammad Alsolaiman
Mohammad AlsolaimanFlag for Saudi Arabia asked on
Microsoft SQL Server* Web HostingWindows 10AzureWindows Server 2016
7 Comments2 Solutions22 ViewsLast Modified:

Hello,

Hosting environment:
Database server: Microsoft SQL Server Express (64-bit)
Operating system: windows server 2016 datacenter (10.0)
Platform: Windows.
Version: 14.0.2037.2
Language: English (United States)
Memory: 3584 MB.
Processor: Intel® Xeon® Platinum 8171M CPU @ 2.60GHz
Installed memory (RAM): 3.50 GB
System type: 64-bit Operating System, x64-based processor
HD size: 120 GB.
 
I have a cloud web application serving the Auto Repair centers.
Customers asking for adding attachments (uploading bills images feature).
 
Note: I create a new database for each new business (Auto Repair center).


My question is what is the best practice of doing such a thing?
For instance:
1. Where to save the uploaded images, save it to the database directly, or save a link  only and the image itself will be saved on the hard disk of our hosting server?
2. How could I calculate the space I need for each Auto Repair center?
3. The rapid increase of stored images will harm my system, is there any suggested plan for increasing the size needed accordingly?
4. Should I use tools to reduce the size of pictures? Any suggestion which tool is best to do this job?
5. Should I need the help of 3rd party company to help me with a complete solution?


If anybody has the experience with this, please help.

ASKER CERTIFIED SOLUTION
ste5an
Senior Developer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros