Limitations of the Number of Entries in a Lookup

Reported for version 10

What are the limitations for the number of items in a lookup?

The best practice with lookups is that they should fit into memory. Note, that the lookups are not kept inside the memory of DQC process, but in cached memory, i.e., you cannot control the size via -Xmx parameter in DQC. Lookups use the free memory of the machine. This means that they may be thrown away by other processes on the machine that would like to consume cached (free) memory.