The big difference is that if it's in the filesystem, the front-end web server can serve the file without any dynamic content at all, whereas if it's in the database, you involve the front-web server, application server, and DB server.
All of which are not that much of a problem, except for the DB. Every scaling problem I've ever seen that was non-trivial to fix was related to DB contention.