Hi,
I have a large CSV lookup (~200MB and 6+ million lines). As I need the lookup information for eventtypes I tried to invoke it as an automatic lookup. As an automatic lookup it is a big performance killer (up to 50 sec in a test query) as it is not when I use it in the search window with the SPL (3 sec in the same test query with inputlookup).
I tried both KVStore and CSV lookup and also raised max_memtable_bytes to 250 MB.