Well, in MySQL-land, there are PatG's UDFs (user defined functions, basically little SQL functions that are written in C and linked into a running server) that allow queries and statements to read and update a memcached from inside the db server.
You could have someone who knows how to write binary extention functions to MS SQL server write ones that do the same sort of thing. If you do, it would be wise to open source it so other people can review and improve them (good for you), and reuse them (good for everyone). On Wed, Mar 3, 2010 at 8:25 PM, JustinSD <[email protected]>wrote: > We are very heavy putting logic in T-SQL in terms of stored procedures > and triggers. The problem, being, when notifications are created, they > are actually created by a trigger. Also we mark notifications are > viewed with a stored procedure. How then can a T-SQL trigger or stored > procedure update memcache? Is that possible? It would be AMAZING if we > could create and update memcache directly in T-SQL triggers and stored > procedures. > >
