) ENGINE=MyISAM - table is recreated monthly, MyISAM is the perfect engine I have other sources to optimize, but optimizing the IP2Location™ LITE IP-ASN Database found at would be a proof of concept.
Otherwise, I'll either be systematically comparing bit shifts (i.e., blindly shift for each possible netmask (from 0 to 24 bits)). In order to benefit from this in an indexed manner, I would need to know the subnet mask (the number of bits to shift). It occurs to me I can store the right shifted number and could match similarly shifted IP address (660510 in the case of select | | If I want to see which network contains an address then I look where ip between start_ip and end_ip which seems less than desirable. The starting and ending ip addresses are indexed. What is the fastest way to determine if an IP is contained within a CIDR block?Īt the moment, whenever I store a CIDR address I also create two columns for starting and ending ip addresses.
0 kommentar(er)
