how to do one time updation and avoid table updation not to be in iteration?

[hbmarar]

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