Hi folks,
I'm working on a simple CMS (actually started it for learning Catalyst,
but the goal is to be able to maintain a few websites with it). Each
page is stored in DB and it can have file attachments, also stored in DB
(content is BLOB).
When serving an attachment, instead of always retriev
On 06/06/2009, at 9:17 PM, Mihai Bazon wrote:
Hi folks,
I'm working on a simple CMS (actually started it for learning
Catalyst,
but the goal is to be able to maintain a few websites with it). Each
page is stored in DB and it can have file attachments, also stored
in DB
(content is BLOB)
Mihai
Mihai Bazon wrote:
Hi folks,
I'm working on a simple CMS (actually started it for learning Catalyst,
but the goal is to be able to maintain a few websites with it). Each
page is stored in DB and it can have file attachments, also stored in DB
(content is BLOB).
I may get shot down in
Kieren Diment wrote:
> >
> > When serving an attachment, instead of always retrieving it from DB I
> > want to save them in a cache directory. So the first time a file is
> > requested, it will be fetched from DB, saved in cache, then I want the
> > Web server to do the job as if it were a static
On Jun 6, 2009, at 7:41 AM, Ian Docherty wrote:
Mihai Bazon wrote:
Hi folks,
I'm working on a simple CMS (actually started it for learning
Catalyst,
but the goal is to be able to maintain a few websites with it). Each
page is stored in DB and it can have file attachments, also stored
in D
From: "John Romkey"
I agree whole-heartedly.
There are very few drawbacks to serving directly from the filesystem
(only one I can think of, which has to do with access control to the
content),
Sometimes the static content shouldn't be accessible at a permanent URL for
security reasons.
A
On 6 Jun 2009, at 14:34, Octavian Râsnita wrote:
From: "John Romkey"
I agree whole-heartedly.
There are very few drawbacks to serving directly from the
filesystem (only one I can think of, which has to do with access
control to the content),
Sometimes the static content shouldn't be ac
John Romkey wrote:
> On Jun 6, 2009, at 7:41 AM, Ian Docherty wrote:
> > Mihai Bazon wrote:
> >> Hi folks,
> >>
> >> I'm working on a simple CMS (actually started it for learning
> >> Catalyst,
> >> but the goal is to be able to maintain a few websites with it). Each
> >> page is stored in DB a
Mihai Bazon wrote:
John Romkey wrote:
On Jun 6, 2009, at 7:41 AM, Ian Docherty wrote:
> Mihai Bazon wrote:
>> Hi folks,
I am aware of the performance quirks
Good.
MySQL blobs are pretty fast, btw.
Ah :)
I'm interested about this. Do you have numbers?
Performance should be (almost)
The way I (and I assume many others) implement image thumbnails could be
the way to go.. (unless you need the access control)
The server handles things as per any normal static content with a 404
handler dealing with missing files. The handler creates and serves the
file so any future requests
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 t
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.
Mihai Bazon 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 save it on disk.
13 matches
Mail list logo