How to manage massive pictures?

godman1982

Created a new database, one table, each record uses 4 image fields to store 4 jpeg pictures, each picture is about 60k, there are 500 records a day, so this database has 60 × 4 × 500 × 365 in one year / 1000 = 43800M = 43G size, may I ask:
1. Can sqlserver manage such big data?
2. How to design to optimize the use and query?
3. Would you like to delete it regularly?
You'd better give me a detailed example to help me as a novice, thank you very much!

lj0917

1, SQL Server can do it
2. This is not a good method. The database tables will be very bloated and not conducive to retrieval.
   -It is recommended to split it vertically and divide it into multiple tables so that it is easy to manage, but it is difficult to handle so many pictures

zhang_mop

What if you use the write path method

dream88

It is recommended to compress before saving and decompress when reading

kislvens

It's better to use the path method

terrorlin

Support the method of saving the path! !!

legend0577

1, yes
2, The picture is stored in another table. Don't put a table with the data
3. See what you need.

awpwangzi

1. Can sqlserver manage such a large amount of data?
     Yes, the image string is a large (up to 2 GB) character or binary string stored outside the data line
2. How to design to optimize use and query?
     Create an index on this table. If you don’t need to query pictures for each query, it is recommended to build another table to save pictures
3. Do you want to delete it regularly?
     base on needs

nickylsy041

If your pictures don't have to be stored in the database, just save a path.