Mailing List Archive


Back to the month index Back to the list index
rasmus@lerdorf.on.ca
Thu, 9 Jan 1997 18:16:30 -0500 (EST) 

From: rasmus@lerdorf.on.ca
Date: Thu, 9 Jan 1997 18:16:30 -0500 (EST)
Subject: Re: [mSQL] Re: 2.0 - can it cache results?
Message-Id: <ML-2.3.852851790.9124.rasmus@krone.lerdorf.on.ca>

> There are development libraries for Apache to allow fastCGI. This would
> allow you program to preform a query once for as many connections it
> needed. I think this may me an interesting way to preformance tunr the
> larger queries.

The problem with this idea is that on a busy server you will need more than
a single fastcgi persistant process. Unless you go out of your way to make
a perfect multi-threaded process. That in itself is certainly non-trivial.

Therefore, once you have multiple fastcgi processes running, you would need
to maintain separate caches in each. And these processes would need to
share their caches with each other? Ouch! This would get very ugly, and
you couldn't pay me enough to build a system based on that.

-Rasmus
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!