Since this is fairly static data, preprocess the on-disk format to match your me... | Hacker News

Hacker Timesnew | past | comments | ask | show | jobs | submit

		vlovich123 on Oct 27, 2024 \| parent \| context \| favorite \| on: Using less memory to look up IP addresses in Mess ... Since this is fairly static data, preprocess the on-disk format to match your memory layout and just mmap the file so that your memory usage for the DB is effectively 0 and the OS kernel pages it in/out for you based on system-level needs?

mstremer on Oct 27, 2024 [–]

Or get a ready-made solution like libloc that implements this already with a tree, deduplication and blazing-fast lookups.

See https://location.ipfire.org/

1a527dd5 on Oct 29, 2024 | [–]

I feel like you should add a slight disclaimer that you are involved in the project in some capacity :)

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact