Hello everyone,
In the Intranet application I've been building over the past 9 months, I have
developed quite a beast of a search. I've asked for help here in the past on
performance tuning it, and have come to the conclusion that I've gotten it as
tweaked as I can without seeking the counsel of a shamen.
What I'm looking at doing is improving in-page performance. In a nutshell, how
expensive is it to create a temporary table? I'd like to do something like:
CREATE TEMP TABLE SearchResults AS [......];
I could then do some queries against the temporary table without having to
regenerate the results every time I want to show a "Page 299 of 500" toolbar.
Would I be better off just sucking this data into an in-memory data structure,
or can I use a temp table as an easy-to-use alternative?
--
/* Michael A. Nachbaur <mike@nachbaur.com>* http://nachbaur.com/pgpkey.asc*/
...[Arthur] leapt to his feet like an author hearing the phone ring...