[Tfug] RDBMS reprise

[Judd Pickell]

Well I guess there is no system is not frought with peril.. :)

Okay, how about non db solution? Why not have the dbms save an xml
file to disk with the query result, and use a script to parse return
results to the client. Either via AJAX, or via simple call the page
load the results type of thing. Of course there is no tried and true
process for making sure created files are removed, but I guess if you
timestamp it with the sessionid, you could easily discover which ones
should be removed. This would keep both server resources and client
resources low.

Sincerely,
Judd Pickell

On Jan 22, 2008 10:54 AM, Bexley Hall <bexley401 at yahoo.com> wrote:
> Hi, Judd,
>
> --- Judd Pickell <pickell at gmail.com> wrote:
>
> > What if you have the cursor create a temporary table
> > to to store the
> > query data. There are probably a number of ways to
> > do it, and a stored
> > procedure would probably work best. As far as I know
> > a compiled stored
> > procedure is the fastest way to execute a query on
> > the server so even
> > if it was a large data set, it could be done quickly
> > so minimizing
>
> Yes, that was my point.  I have to let the result
> table sit on the server (since I don't have the
> resources to hold the *entire* result set on the
> client -- and the "piece-meal" approaches aren't
> atomic)
>
> > server usage. I am not entirely clear if the temp
> > table is stored in
> > memory or on disk. I guess that would depend on
> > which DBMS you are using.
> >
> > Basically with the temp table, it will be destroyed
> > at the end of the
> > client session so minimal server resource usage,
> > static content, then
> > you could implement the bite at a time approach,
> > spreading the
> > resources across all components (client and server).
>
> Right.  But, even this approach isn't without
> peril -- the server itself has bounded resources
> so if *this* client lingers in processing and
> DROPing the result table, then other clients
> will not be able to have *their* requests
> satisfied (since they will adopt the same
> "store it on the server" strategy)
>
> --don
>
>
>       ____________________________________________________________________________________
> Never miss a thing.  Make Yahoo your home page.
> http://www.yahoo.com/r/hs
>
>
> _______________________________________________
> Tucson Free Unix Group - tfug at tfug.org
> Subscription Options:
> http://www.tfug.org/mailman/listinfo/tfug_tfug.org
>