Re: Bind message
От | Markus Schaber |
---|---|
Тема | Re: Bind message |
Дата | |
Msg-id | 451846B0.6070906@logix-tt.com обсуждение исходный текст |
Ответ на | Re: Bind message (Kris Jurka <books@ejurka.com>) |
Ответы |
Re: Bind message
|
Список | pgsql-jdbc |
Hi, Kris, Kris Jurka wrote: > Sometimes it is, sometimes the purpose of using a PreparedStatement is > to avoid escaping data yourself for a plain Statement execution. There > are potential performance penalties for using a "reusable" server side > prepared statement because it plans them with generic parameters, not > those supplied in your query. For this reason we want to be sure that > people will actually be reusing these statements before switching to > this mode. I believe the default prepareThreshold is set to 5 despite > what the documentation says. I remember having read something about delaying the actual planning until the first parameterset arrives. Am I mislead by my weak memory? Thanks Markus -- Markus Schaber | Logical Tracking&Tracing International AG Dipl. Inf. | Software Development GIS Fight against software patents in Europe! www.ffii.org www.nosoftwarepatents.org
В списке pgsql-jdbc по дате отправления: