LISTEN question

Поиск
Список
Период
Сортировка
От mikael-aronsson
Тема LISTEN question
Дата
Msg-id 222501c760ab$0f018360$e0be42d5@w128mtec
обсуждение исходный текст
Ответы Re: LISTEN question  ("Andres Olarte" <olarte.andres@gmail.com>)
Список pgsql-jdbc
Hi !

Does any one have any idea on the impact of using a large number of
different LISTEN,
say that I add 20 "LISTEN something;" statements will this slow down the
client much ?

The thing is that I have 20 different tables and I would like to be notified
when something
change in any of the tables, there are timestamps so I can use SELECT * FROM
xxx
WHERE timestamp>zzz to get the changed data but going to put out 20 SELECT
queries all the time does not sound very smart so I thought I would use
LISTEN/NOTIFY instead to improve performance.


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

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: Transaction atomicity
Следующее
От: "Andres Olarte"
Дата:
Сообщение: Re: LISTEN question