On Wed, 2002-10-23 at 10:39, Greg Copeland wrote: > If you were using them that frequently, couldn't you just keep a > persistent connection? If it's not used that often, wouldn't the > overhead of preparing the query following a new connection become noise?
Especially by the time you add in the dependency tracking (drop table, query must go), and modifications to analyze to clear out the stored list. > On Wed, 2002-10-23 at 09:24, Hans-Jürgen Schönig wrote: > > First of all PREPARE/EXECUTE is a wonderful thing to speed up things > > significantly. > > I wonder if there is a way to store a parsed/rewritten/planned query in > > a table so that it can be loaded again. > > > > This might be useful when it comes to VERY complex queries (> 10 tables). > > I many applications the situation is like that: > > > > a. The user connects to the database. > > b. The user sends various different queries to the server (some might be > > the same) > > c. The user disconnects. > > > > If there was a way to store execution plans in a table the user could > > load the execution plans of the most time consuming stuff into the > > backend without parsing and optimizing it every time he authenticates. > > > > Does it sound useful to anybody? Is it possible to do it or are there > > some technical problems? > > > > Maybe this is worth thinking about. > > > > Hans > > > > -- > > *Cybertec Geschwinde u Schoenig* > > Ludo-Hartmannplatz 1/14, A-1160 Vienna, Austria > > Tel: +43/1/913 68 09; +43/664/233 90 75 > > www.postgresql.at <http://www.postgresql.at>, cluster.postgresql.at > > <http://cluster.postgresql.at>, www.cybertec.at > > <http://www.cybertec.at>, kernel.cybertec.at <http://kernel.cybertec.at> > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 6: Have you searched our list archives? > > > > http://archives.postgresql.org > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > -- Rod Taylor ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
