Re: [Catalyst] Serving static content from DB

2009-06-07 Thread Mihai Bazon
Look, I think I didn't properly explain what I need. Or, maybe you didn't read all my email and just noticed that I intend to keep file content in a BLOB. :-) I do want to keep files in the DB, BUT serve them as static files. The backend-db traffic is unimportant, as it will happen only when

Re: [Catalyst] Serving static content from DB

2009-06-07 Thread Bill Moseley
On Sun, Jun 07, 2009 at 03:01:58PM +0300, Mihai Bazon wrote: I do want to keep files in the DB, BUT serve them as static files. The backend-db traffic is unimportant, as it will happen only when the file is updated. Of all parts to a web app the database is probably the hardest to scale.

Re: [Catalyst] Serving static content from DB

2009-06-07 Thread Cosimo Streppone
Mihai Bazon mi...@bazon.net wrote: I wrote some tests, since you ask me about numbers. You can download it here to run it yourself: http://mihai.bazon.net/Static-VS-DBI.tar.bz2 Excellent! Thanks for this. Will look into it. 1. is the file cached? - If not, retrieve from DB then