我们的应用程序应该将图像属性存储在数据库中吗 或者应用程序应该在运行时生成它们？

Question

So my application is simple. It is a laravel 5 framework running a desktop template website.

My question is a performance question. Should we store the image properties in a database like MySQL or should we just generate them on the fly? The properties would be simply image resolution, image file size, image color properties, also file extension.

Thanks in advance!

Answer 1

My advice is never generate images on fly when performance is a concern, rather generate different sizes once, save them in certain folder say uploads\images or read the image properties once during upload(to avoid doing so on each image request) and store properties in a DB table.