I'm sorry, I really don't know what resin you should use, it is highly dependent on the application. For instance, having some organic material could change the game. I suggest you get small amounts of a bunch of diferent ones and try them out in little lab columns. Also, talk to the manufacturers, they are true experts in this field. They are trying to sell you something, but if you can get an actual scientist on the phone instead of a rep, you'll probably get honest answers to all these questions, and probably higher quality ones that I can give.
The manufacturers often will provide specs on how many cycles the resin will reasonably last.