Re: Slow query after upgrades

Поиск
Список
Период
Сортировка
От Albert László-Róbert
Тема Re: Slow query after upgrades
Дата
Msg-id 1197630927.6335.37.camel@albertlr-rss
обсуждение исходный текст
Ответ на Re: Slow query after upgrades  (Kris Jurka <books@ejurka.com>)
Список pgsql-jdbc
On Fri, 2007-12-14 at 05:24 -0500, Kris Jurka wrote:
>
> On Fri, 14 Dec 2007, Albert Lszl-Rbert wrote:
>
> > the performance before were arount 1-2 minutes ... and after the upgrade
> > it was about 30-40 minutes and more ... but because our application is
> > running throw the internet using the CORBA technology in most of the
> > cases the database throws an org.postgresql.util.PSQLException(: An I/O
> > error occured while sending to the backend.) exception.
> >
>
> I don't understand why running slower results in IOExceptions.  Is the
> driver actively broken, or is your app just slower?
>

Generally the use of the driver is OK, but with some of the queries (for
the moment we've got feedback for two heavily used queries) we had this
kind of error. When we ran the query from the console we've got the same
result (it was faster than through the JDBC driver).

> Kris Jurka
--
László-Róbert, Albert
mobile: +40-(0)-742-874-854
office: +40-(0)-365-410-540
e-mail: albertlaszlorobert@gmail.com


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

Предыдущее
От: Altaf Malik
Дата:
Сообщение: Re: JDBC causing the connection to close after executing a COPY command
Следующее
От: Albert László-Róbert
Дата:
Сообщение: Re: Slow query after upgrades