prepared statement performance

Поиск
Список
Период
Сортировка
От Sheer El-Showk
Тема prepared statement performance
Дата
Msg-id Pine.LNX.4.33.0107091445080.26310-100000@laudanum.saraf.com
обсуждение исходный текст
Список pgsql-jdbc
Does anyone have some handy metrics of the performance advantage of
prepared vs unprepared statements?  I'm considering the case of an
application which has to make multiple queries/inserts (30-100) per
application transaction and which is currenlty generating the sql by
building the strings on the fly then passing them to the JDBC.  Can I
expect significant (ie worth the recoding time) performance increases by
converting the statements into prepared statements?

Thanks,
Sheer


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Joseph Shraibman
Дата:
Сообщение: Re: Patch to remove connection hook and JDK 1.3 dependencies
Следующее
От: Joseph Shraibman
Дата:
Сообщение: Re: Re: Patch to remove connection hook and JDK 1.3 depen