Shawn,
I like your idea very much. Unfortunately I am not using version 5 yet,
but this may hasten my upgrade.
My initial thought was to try and find a function like PostgreSQL's
LISTEN command
(http://www.postgresql.org/docs/8.0/interactive/sql-listen.html). But I
think this method is bette
You could make your polling query as light weight as possible.
Create a new table with a single integer. When an update happens
increment that integer. Your polling query will then just be a select
from that table to see if the number has been incremented from the
last time it performed the operat
Ben Clewett <[EMAIL PROTECTED]> wrote on 03/21/2005 11:36:45
AM:
> Dear MySQL,
>
> I have an application which need to wait for some data to change, then
> act on this change.
>
> I am polling the MySQL once a second using "SELECT ..."
>
> I believe there is an alternate method where a thread
Dear MySQL,
I have an application which need to wait for some data to change, then
act on this change.
I am polling the MySQL once a second using "SELECT ..."
I believe there is an alternate method where a thread can be made to
wait for some change, therefore avoiding the expensive polling and