Wednesday, March 28, 2012

Images in SQL db

Hi all,
is it good practice to store product images in a sql db?

thanksSure,
Why not?
If you have the suffecient amount of disk space,
You can do it and with no problems,

Cheerz|||::is it good practice to store product images in a sql db?

Yes, it is the bes t thing you can do.
No, it is riiculously stupid.

And now the truth: tis is somewhere between, and it totally depends on what you do with them.

I WOULD store them in the DB - simply because this means ONE backup location for the complete shop (you talk of a shop here, right?), as well as referential integrity.

OTOH this means I HAVE to use the output cache to get decent server performance, which means I need more memory. Which is a negative. Some consider it a hugh negative, me not - the output cache is pretty smart about dropping stuff, AND - more important - memory is cheap. Cheaper than the developer having to write a cleanup routine because you have left-over stuff in the db.

It really depends a lot on WHAT you do with the images.|||Well, what is your reasoning for placing them in the db?|||Nice one thanks everyone.

No comments:

Post a Comment