After reading the post, and considering the time of export/import the data, I think will be better to denormalize the data (ie:precalculate the result).

I have something like in the near past, but with much heavy calculations. Denormalizing using triggers turn query that take minutes in less 1 second.