If the lookup has not enough memory, it will flush to disk.

So you might have a memory issue.

How did you configure the lookup? I hope you didn't use the dropdown menu...