Re: [GENERAL] Prepared statement performance...
От | Shridhar Daithankar |
---|---|
Тема | Re: [GENERAL] Prepared statement performance... |
Дата | |
Msg-id | 3D9224A0.24866.F92EFA3@localhost обсуждение исходный текст |
Список | pgsql-jdbc |
On 25 Sep 2002 at 11:14, Dmitry Tkach wrote: > Hi, everybody. > > I am running into huge performance problems, due to JDBC not being able to cache query plans :-( > My java program runs the (set of about 5) identical statements with different parameters for about 30 million times... > What I am talking about below has to do with JDBC, but is not really specific to it - it seems to me, that the backenditself > could be improved to better handle this kind of scenario, when the same statement is executed many times in the same session. > - a general solution, that would involve extending postgres SQL gramma to include a 'prepare' statement Added in upcoming 7.3.. So youmight want to test the betas or CVS.. Just wondering.. Would you see any performance difference in case you put the statements in pl/pgsql functions? Just a thought.. Bye Shridhar -- The Sixth Commandment of Frisbee: The greatest single aid to distance is for the disc to be going in a direction you did not want. (Goes the wrong way = Goes a long way.) -- Dan Roddick
В списке pgsql-jdbc по дате отправления: