Re: Performance problems inside a stored procedure.

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Performance problems inside a stored procedure.
Дата
Msg-id 479DC558.30409@enterprisedb.com
обсуждение исходный текст
Ответ на Performance problems inside a stored procedure.  (Matthew Lunnon <mlunnon@rwa-net.co.uk>)
Ответы Re: Performance problems inside a stored procedure.  (Matthew Lunnon <mlunnon@rwa-net.co.uk>)
Список pgsql-performance
Matthew Lunnon wrote:
> I have a query which runs pretty quick ( 0.82ms) but when I put it
> inside a stored procedure  it takes 10 times as long (11.229ms).  Is
> this what you would expect and is there any way that I can get around
> this time delay?

It depends. You'll need to show us the function. Also, what version of
Postgres are you running?

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

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

Предыдущее
От: Matthew Lunnon
Дата:
Сообщение: Performance problems inside a stored procedure.
Следующее
От: Matthew Lunnon
Дата:
Сообщение: Re: Performance problems inside a stored procedure.