handling lots of relational meta-data

Hello,

So I have a custom post type called ‘hotels’ and one called ‘landmarks’. I have all these coordinates of the hotels and the landmarks in custom fields in WordPress.

I also have created a spreadsheet with values for the distance, in miles, between any given hotel and any given landmark. This adds up to over 100,000 values. That’s obviously a lot of metadata.

I could store 100 or so distances as custom fields in all of these hotels, but that seems like a bloated way to do this. I’m wondering if there’s a specific plugin or method to handle all this data.

It occurred to me that social media is all about the relationships between people, so I wonder if there’s some kind of buddypress-related plugin that would help me store this data.

Anyway, let me know, thanks.