MongoDB index and query strategy to fetch a record within range bounded by two fields
Our IP address ranges table has ~2.8 million records, of the following structure: { start_ip: integer, // IPv4 converted to int32 end_ip: integer, // IPv4 converted to int32 country_code: string, country: string, region: string, city: string } There is a…