Mailing List Archive


Back to the month index Back to the list index
Eric Warnke (ericw@albany.edu)
Thu, 09 Jan 1997 13:04:13 -0500 

Message-Id: <32D5331C.5B16@albany.edu>
Date: Thu, 09 Jan 1997 13:04:13 -0500
From: Eric Warnke <ericw@albany.edu>
Subject: Re: [mSQL] Re: 2.0 - can it cache results?

Mark H. James wrote:
> On Wed, 8 Jan 1997 10:48:07 -0800, Gary Bickford wrote:
> >As Rasmus pointed out, the connection ends when the web page ends, so in
> >this application there would be no point in having temp tables unless they
> >can persist.
> >
>
> I guess the results of a view are not necessarily cached, however,
> just the query path -- but that probably would speed complex queries.
>
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.

Eric Warnke
Sysadmin ResNet
University at Albany, NY
ericw@albany.edu
--------------------------------------------------------------------------
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!