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 <[EMAIL PROTECTED]> * http://nachbaur.com/pgpkey.asc */ ...[Arthur] leapt to his feet like an author hearing the phone ring... ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
