Temporary table performance?
От | Michael A Nachbaur |
---|---|
Тема | Temporary table performance? |
Дата | |
Msg-id | 200306260914.41245.mike@nachbaur.com обсуждение исходный текст |
Ответы |
Re: Temporary table performance?
|
Список | pgsql-sql |
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...
В списке pgsql-sql по дате отправления: