question

VuyiswaMaseko-8882 avatar image
0 Votes"
VuyiswaMaseko-8882 asked RedShanks commented

Storing images on file system as compared to db

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

dotnet-sqlite
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,

What do you mean 'follow the text to the DB serialized text'? Please share more details about that.

0 Votes 0 ·

0 Answers