One thing to consider is maybe sqlite r-tree.

[simonvh]

To consider.. not sure about this yet.

One thing to consider is maybe sqlite r-tree. It's the perfect datastructure for this (linking proximalish peaks with tss) I think, and should be fast / dynamic. I implemented it for peaksql, and I could try a bit if it's (much) faster. The advantage is that we can put everything on disk, so the memory usage should be very low, and sqlite in general is fast. Big disadvantage is maintainability and perhaps portability between systems..

Originally posted by @Maarten-vd-Sande in https://github.com/vanheeringen-lab/ANANSE/pull/37#discussion_r579235365