Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are the advantages of using UDFs when the get/sets are manageable from within the client code rather than the db?

0
Posted

What are the advantages of using UDFs when the get/sets are manageable from within the client code rather than the db?

0

Sometimes you want to be able to be able to update the information within memcached based on a generic database activity, rather than relying on your client code. For example, you may want to update status or counter information in memcached through the use of a trigger or stored procedure. For some situations and applications the existing use of a stored procedure for some operations means that updating the value in memcached from the database is easier than separately loading and communicating that data to the client just so the client can talk to memcached. In other situations, when you are using a number of different clients and different APIs, you don’t want to have to write (and maintain) the code required to update memcached in all the environments. Instead, you do this from within the database and the client never gets involved.

Related Questions

Thanksgiving questions

*Sadly, we had to bring back ads too. Hopefully more targeted.