hi,
I got a daily task script that does the job as below:
#1. Calculate score for one time, count and rank using 4 auxillary empty tables, using data from few other main tables.
#2. Now, i start iterating 5 times to get my score for each user stabilised based on algorithm.
#3. if last iteration, get few tables updated.
In the #2, i have a table A that gets one of its column updated in each iteration. All the tables are innodb type. But, how to avoid this updation in every iteration? Is it possible for a one time updation? Should I use another 5th auxiallary table for this?
I do not know much on this and so posting it here for the experts pointers and suggestion.
Thanks in advance
Hari