Mailing List Archive


Back to the month index Back to the list index
Gary Bickford (garyb@outlawnet.com)
Tue, 14 Jan 1997 09:22:31 -0800 

Message-Id: <v01540b02af016fbd054d@[208.192.38.113]>
Date: Tue, 14 Jan 1997 09:22:31 -0800
From: garyb@outlawnet.com (Gary Bickford)
Subject: Re: [mSQL] 2.0 - can it cache results?

>> Then I think the best idea is to forget about the idea of temporary tables.
>> Implement the real ANSI "select into" clause and let the client-side worry
>> about dropping tables that may no longer be needed.
>
>But then that gives the worst of both worlds. The applications have to
>work out a way to try to generate a unique name for the table (as there
>may be many people running the same query at the same time). You can't
>just chuck a PID on the end as the app's could be running on various
>machines client/server.

Well, as an application developer, I'm willing to deal with these issues
myself. Certainly it could allow the application to explode. But I've got
the same problem now - I've got a bastard cache scheme that spools the
output to a "temp" file, which I have a cron job deal with. I personally
hate it... My plan is/was to eventually store a tag to these result files
in a table, and reuse them, but I haven't had time and the volume on the
server is so low it's not a problem - yet.

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!