Mailing List Archive


Back to the month index Back to the list index
David J. Hughes (bambi@Hughes.com.au)
Wed, 15 Jan 1997 01:07:48 +1000 (EST) 

Date: Wed, 15 Jan 1997 01:07:48 +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.970115010512.687r-100000@webster.AusWeb.com.au>

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

You also still get the problem of someone htting a certain web page a few
dozen times and filling up your disk space. Yet another denial of
service attack in the making. I'd hate to see a CERT advisory come out
about mSQL! :)

This one needs some more thought. I'm sure there's a good solution out
there. It's just a matter of working out how to make the feature of use
for Web based stuff.

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!