Maximum query size is 64Mb - but you also have to take into account that after you parse a USE KEYS clause that large, you then have a huge parse tree and even bigger plan.
The execution layer would then have an evaluated array of keys of probably 8 million entries, so if you go that route and use the max statement size, you could actually blow up memory.