What is the best format to store images in a database, such as binary,base64...etc, for optimal speed/size.
Blob is the answer for your question.
Instead of storing image to database directly you can store the image in hard disk And store the filename in database.I think this way is appropriate.Performance wise this is good.
Microsoft's advice for SQL Server used to be, for speed and size, store images in the file system, with links in the database. I think they've softened their preference a bit, but I still consider it a better idea certainly for size, since it will take up no space in the database.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With