It's highly optimized, but it still needs quite a bit of RAM when the index is large. But RAM is cheap nowadays. It's the only thing I really, really miss when I am on Linux. (there is FSearch, but it's not quite as great, yet)