Clearing connection pool

mySQL triggers can contact the clients? cool

Quote:

---

Originally Posted by cjard

mySQL triggers can contact the clients? cool

---

Unfortunately they can not do all of the things that you can do with SQLServer. But they can definately reduce the overload of scanning tables for changes.

Also the availability of the Compact Edition of SQLServer has really reduced the number of situations where mYSQL has significant benefits.

Quote:

---

Originally Posted by cjard

mySQL triggers can contact the clients? cool

---

This is not correct. Triggers only work from within the database. MS Sql 2005 and above have Notification Services that allow .Net clients to receive notifications when data has changed in one or more tables.

Quote:

---

Originally Posted by Arjay

This is not correct. Triggers only work from within the database. MS Sql 2005 and above have Notification Services that allow .Net clients to receive notifications when data has changed in one or more tables.

---

There are also notification packages available for MySQL. These vary greatly in capabilities (and in my experience, none of them are nearly as powerful as the services provided by SQLServer2005) For example SQLyog allows the automatic sending of e-mails based on internal actions.