I've tried to observe how this app works.
It actually forces OS X's native memory management to kick in.
It does this by using an obscene amount of memory for a very short amount of time. This forces OS X to clean up the existing RAM in use as the RAM used by Memory Cleaner builds up dramatically.
In this way its partially cosmetic since your RAM would be cleaned up if you used more of it anyway.