Do you have a question? Post it now! No Registration Necessary. Now with pictures!
November 24, 2005, 4:42 pm
rate this thread
Re: MySQL queue/messaging
MySQL has no event mechanism. You could have the client application
that performs the insert notify other clients. Or you could have the
monitoring client check periodically for new records, sleeping in
between. This is sometimes called "polling".
If the table it is monitoring has a lot of records, checking for new
entries is costly, so it might be better for the client that does the
insert to also post a record to a separate table, to indicate that a new
record has been added. The monitoring client watches this table, and
delete records as it processes them. This keeps the table shorter, and
therefore polling it is less costly.
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum