Every modification which adds functionality will increase resource usage - it's physically impossible for them not to. That being said we've not had a single report that our user tagging mod is particularly resource intensive.
I would recommend trying the standard (lite) version first to check - the usage of the pro version won't be much different.
Cosmic