Should Static Files Be Placed In The Database?

1.	Should Static Files Be Placed In The Database?
Answer» Application Express applications may reference additional external files such as cascading style sheets (CSS), IMAGES and Javascript LIBRARIES. These images can either be placed on the file system of the server that runs the WEB server or, when they are uploaded using Application Express’s application builder, can be stored inside the DATABASE. A benefit of managing files such as images and CSS in the database with the application builder is that they can be exported and imported into another Application Express environment or workspace using only a browser. However, storing related files in the database is recommended only when you have relatively few images and when the application is not expected to endure high request THROUGHPUT. When images, CSS and Javascript libraries are stored in the database, a database connection is established each time the browser requests one of these files. In a high throughput application this may result in undue and unwanted strain on the database.

Answer»

Application Express applications may reference additional external files such as cascading style sheets (CSS), IMAGES and Javascript LIBRARIES.
These images can either be placed on the file system of the server that runs the WEB server or, when they are uploaded using Application Express’s application builder, can be stored inside the DATABASE.
A benefit of managing files such as images and CSS in the database with the application builder is that they can be exported and imported into another Application Express environment or workspace using only a browser.
However, storing related files in the database is recommended only when you have relatively few images and when the application is not expected to endure high request THROUGHPUT.
When images, CSS and Javascript libraries are stored in the database, a database connection is established each time the browser requests one of these files.
In a high throughput application this may result in undue and unwanted strain on the database.

Discussion