Mailing List Archive


Back to the month index Back to the list index
Mark H. James (markj@3cat.com)
Thu, 09 Jan 97 02:36:26 -0400 

Message-Id: <199701090228.VAA25934@tiger.3cat.com>
From: "Mark H. James" <markj@3cat.com>
Date: Thu, 09 Jan 97 02:36:26 -0400
Subject: Re: [mSQL] Re: 2.0 - can it cache results?

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.
>
>You bring up a good point though - how are the commercial dbms folks
>handling this in their new web server packages?

If we are talking about persistent temp tables (sounds like a pretty
good oxymoron to me<g>), is that the same thing as a view under SQL?

I guess the results of a view are not necessarily cached, however,
just the query path -- but that probably would speed complex queries.

It seems like having to build your own intermediate layer to cache
results could end up recreating mSQL all over again -- it seems like
the answer may be to create new tables of the results from common
queries, and somehow keep track of their age and success in answering
new queries.

By the way, I'm not sure the commercial systems are all that
intelligent yet -- I think a lot of them are just a front end into
the normal query channels, and the performance is not so great in
some cases.

It seems like the best performance is usually going to come from a
custom approach -- with all the cost that that implies.

But I'm just rambling ....

Mark H. James | markj@3cat.com
Three Cat Software | http://www.3cat.com
Web Development | 73266.2400@compuserve.com

--------------------------------------------------------------------------
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!