Mailing List Archive


Back to the month index Back to the list index
David J. Hughes (bambi@Hughes.com.au)
Tue, 14 Jan 1997 23:59:25 +1000 (EST) 

Date: Tue, 14 Jan 1997 23:59:25 +1000 (EST)
From: "David J. Hughes" <bambi@Hughes.com.au>
Subject: Re: [mSQL] 2.0 - can it cache results?
Message-Id: <Pine.SUN.3.91.970114235637.687I-100000@webster.AusWeb.com.au>

> > The logical way to do this is to link the tmp table to the session handle
> > in msql2d. That way it can be cleaned up at the end of the session and
> > all is well. The down side is that it will not help web based app's as
> > each page generates a new session :-(
>
> Linking it to the session handle would sort of defeat the purpose. Could you
> not create a unique identifier of some sort which map to the new table? You
> would need to create this unique identifier anyway because it is very
> possible that two client apps try to create the same temp table at the same
> time, and one should not fail just because another is doing the same thing.
> So, instead of actually naming the temp table by whatever name the client
> app has specified in the SQL query, a unique identifier needs to be generated
> and made accessible to the client.

The problem with this is that these tables a temporary but there is no
mechanism to enforce that status. The "tagging" convention I mentioned
in my original message handles this temporary nature as ther server can
tell when they are no longer required (in the usual client'server
application sheme of things). The problem is caused by the
connectionless nature of the web in that there's no way of knowing when
the client is through so the client is forced to manually remove the tmp
table (bad plan if you don't have more spare disk space than last year's
production from the Seagate factory).

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