MySQL Forums
Forum List  »  PHP

Re: financial database / data management
Posted by: Federico valori
Date: August 16, 2005 10:15AM

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.



Options: ReplyQuote

Written By
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.