Storing images on file system as compared to db

Vuyiswa Maseko 351 Reputation points
2021-05-22T13:59:10.2+00:00

I'm currently storing my images on the filesystem and store the location of the images. So in Xamarin forms I show them from a url.

I also worked on resizing the images so that the storage size is faster when loading them.

Out if curiosity I created a small example app that serialize the image Byte array and I took the serialized text store it in the database and retrieve it from the database , the speed is amazing. In the table it's stored with varchar(max)

I have the following question with my test

1) is it a going idea to follow the text to the DB serialized text?.
2) is it possible that I might come across an image that have size over varchar (max)? Which night lead to the all crashes

Thanka

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,705 questions
{count} votes