I'm looking to extend the special price functionality in Magento and add some custom logic for when special prices should apply to products.
What is the most efficient way of doing this? Currently, there are observers for whenever the product is loaded (or whenever collections are loaded) and then the module checks if special price applies.
Obviously this way is very slow, what is a more effective way of doing this, possibly when the product itself is being pulled from the DB.
Any thoughts?