If macros are stored in UTF-16, then every macro book is ~288KB, so storing all macros would take ~2.7MB. This shouldn't be any issue at all for the PS2 to handle (and makes my calculations on a previous mage even more feasible, since I assumed 8-bit encoding).
If I understand it correctly, it would be hard to implement. How do you even define optimal? For so much situational gear.. I believe it would require quite some computational power and would only give approximate results. Equipment description is stored in text form, so either it would have to be parsed (which is not possible to do correctly, due to translation errors and hidden/unclear effects) or every item would have to be stored as some sort of struct with all its stats stored internally, which would require a lot of space.
On the other hand, if you wanna do the computation server side, it would be nearly impossible to manage with thousands of active players spamming spells all the time. Or did I misunderstand what you said?
