Re: Why are stored procedures looked on so negatively?

Поиск
Список
Период
Сортировка
От Sébastien Lorion
Тема Re: Why are stored procedures looked on so negatively?
Дата
Msg-id CAGa5y0NE9QqLxAS=z8c5u1LdUJKNjt9jeuA+s497n7w3jyXKZw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Why are stored procedures looked on so negatively?  (Some Developer <someukdeveloper@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Thu, Jul 25, 2013 at 4:41 AM, Some Developer <someukdeveloper@gmail.com> wrote:
You are forgetting that you can execute a query asynchronously using libpq therefore the app server can continue serving requests whilst the database server chugs away on its work. You just poll the server every now and again to see if the work has finished.

I think another option is to use some sort of pub/sub architecture using a messaging server such as RabbitMQ. It would at least allow you to avoid/reduce the locking in the database caused by the remote calls in triggers. It would also allow you to scale out the app servers instead of scaling up the database. That said, depending on your load, it might be overkill.

Sébastien

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

Предыдущее
От: Andrew Bartley
Дата:
Сообщение: Re: Rule Question
Следующее
От: Neil McGuigan
Дата:
Сообщение: How to do incremental / differential backup every hour in Postgres 9.1?