Mailing List Archive


Back to the month index Back to the list index
Fernando Lozano (bl@riosoft.softex.br)
Wed, 8 Jan 1997 10:48:07 -0800 

Message-Id: <v01540b02aef99a901d54@[204.245.248.229]>
Date: Wed, 8 Jan 1997 10:48:07 -0800
From: garyb@outlawnet.com (Gary Bickford)
Subject: Re: [mSQL] Re: 2.0 - can it cache results?
From: Fernando Lozano <bl@riosoft.softex.br>

>> . When should the temp table be deleted? I would prefer if it were left
>> up to the client application to delete it, but it would be neat if
>> it could be given a timeout.
>
>
>All databases I know delete temp tables when the connection ends, and I
>think this is the better approach.

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?

I know many of the big search engines cache result tables, so that's
another source of information. Might as well find out what's been done,
avoid reinventing the wheel and so forth.

GB

end
=======
Gary Bickford, FXT Corporation http://www.fxt.com
System integration, active web site design, intranets.
garyb@fxt.com 541-923-3060

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