Best practise

[DanielLiljeberg]

Hi

I'm wondering a bit what the best practise for handeling files are (images etc). I usualy put them in a folder and link the name of the file in the database. Always thought it to be better than inserting the binary data into the database itself. But are there any real advantages to inserting the binary into the db or is my way "better"?

[bbreslauer]

This is the better way to do it: filesystems are meant to handle files, whereas databases are meant to handle (generally) smaller bits of data. Doing it this way will also keep the database smaller, meaning that it'll take less time to do various operations.