Fatal error: Allowed memory size of xxxbytes exhausted

in any circumstance you should prevent calculations like that in PHP

most of the time if you want to calculate something like that with this type of data you should think about triggers
MYSQL Trigger Doku

Basically you can set after and before triggers in order to react with your action. Allowed are, on update, on insert and on delete triggers.