I need script that will be periodically ( once a day ) calculate some mathematical task . It must take variables from MYSQL database, calculate and put it back as new part of data. This database is not yet fully preapred and we will need about 4-6 scrpits ( or one that will check all the features ).
So we need professional help by preparing the whole concept. We have the bassics but we need database programmer to help us make it as fast as possible.
All will work on freebsd machines with mysql.
Main concept of database and script:
It's about our employees. Everyone will have some stats, that will be updated ( by script everyday ). They will be packed into groups. Once a day we want to make a simulations between groups. The algorithm will be quite hard math. Also we want to have a possibilitie to change this algorithm to observe how this will work.
What we are looking for?
First we need help by concept for data ( how best make a tables, is mysql best choice? etc. ).
Second we want you to preapre it for us ( database main concept and server scripts ).
If you need more info i will gladlly answer...