Re: financial database / data management
Thank for your reply. I am still not sure if i can evaluate all the data i need on-the-fly using the sql logic (annualised volatility, standard deviation etc.. etc...). even if i manage to do so, will it make it slower, if everytime mysql has to evaluate these functions? remember this data is for search and reporting facility.
rememeber that i need all this data for reporting and searchng facilities.
the php functions way seems more reasonable, and I could trigger it in such a way that everytime the information about a product is updated, i.e. new monthly data is inserted, then all the other fields can be re-evaluated and updated.
which way would you say is best?
in both cases i still need access to these financial functions.
thanks
Federico
Subject
Written By
Posted
Re: financial database / data management
August 16, 2005 10:15AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.