Thread: LISTEN question

LISTEN question

From
"mikael-aronsson"
Date:
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.


Re: LISTEN question

From
"Andres Olarte"
Date:
Very little impact.  My client uses about 30-60 LISTENS and it works
great.  And most of my clients are Pentium 3 computers!

On 3/7/07, mikael-aronsson <mikael-aronsson@telia.com> wrote:
> 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.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>