I have few questions about using functions in a MySQL database for plugins and extensions of web apps like Magento or Wordpress. Mostly this is for a few extensions I want to do for Magento. The questions are:
- is it possible under normal average hosts out there, that functions can be added.
- (if 1) is it worth the effort to create function that would replace php in some manner (speed mostly is what I'm thinking)
- (if 1) can functions be looped? like timed or call to it's self x time like sleep or something.
I was wanting to use the db for simple things like removing rows that were older then or something like that. Examples are not as important as possibility here in my mind. This is more of a set of questions that are due to not every really seeing web app use functions, and it just seems like an area of untapped potential for optimization when designing web apps.