Blobs

[cnicolapc]

Hi,

I need an opinion.
Is best stored a photo in a SQL database as a blob ? Or should store the photos in a dedicated folder, and then store only a reference to it?
I do not know the performance of the database SqlLite with a number of photos.
Thank You
Nicola

 

[Erel]

It depends on the number of photos and their sizes.
Unless there are many large photos then SQLite should be fast enough.