user_badges without JOIN operation

I am running a very busy site. I recently added user_badge and the site became very very slow.

The database server was busy creating lots of temp files and this really slowed down everything.

One of the site admin found that the following database query was the cause of this high load.

SELECT DISTINCT b.bid, bweight, b.name , b.image FROM user_badges_badges b INNER JOIN user_badges_us

The JOIN is a very heavy operation in mysql because it requires disk write.

If you can enhance the user_badges module without JOIN operation, that would be great.

Thanks very much for nice module anyway!