Re: Better option then polling ?

2005-03-11 Thread Martijn Tonies
> There's nothing wrong with polling as long as it's > moderate and it doesn't lock resources. > > On a heavily updated table in a large volumen site, it > scales much better than nasty triggers or events > firing all over the place. > > Triggers are intended to maintain internal database > consi

Re: Better option then polling ?

2005-03-11 Thread Homam S.A.
There's nothing wrong with polling as long as it's moderate and it doesn't lock resources. On a heavily updated table in a large volumen site, it scales much better than nasty triggers or events firing all over the place. Triggers are intended to maintain internal database consistency by enforcin

Re: Better option then polling ?

2005-03-11 Thread Yves Goergen
On 11.03.2005 08:18 (+0100), Michael Gale wrote: > I have a table in a database that is constantly being updated with new > information. I would like to be notified if certain information gets > committed. > > Lets say for example the table gets updated every time a login attempt > happens rega

Re: Better option then polling ?

2005-03-11 Thread Martijn Tonies
Hello, > I am fairly new to mysql and have a strange request I am not sure > if "stored procedures" will solve this. > > I have a table in a database that is constantly being updated with new > information. I would like to be notified if certain information gets > committed. > > Lets say for

Re: Better option then polling ?

2005-03-11 Thread Philippe Poelvoorde
Michael Gale wrote: Hello, I am fairly new to mysql and have a strange request I am not sure if "stored procedures" will solve this. I have a table in a database that is constantly being updated with new information. I would like to be notified if certain information gets committed. I thin

Better option then polling ?

2005-03-10 Thread Michael Gale
Hello, I am fairly new to mysql and have a strange request I am not sure if "stored procedures" will solve this. I have a table in a database that is constantly being updated with new information. I would like to be notified if certain information gets committed. Lets say for example the