Hi! We host a very big ip database (around 2 million of records) with ip ranges converted to int numbers, in a schema like: from_ip, to_ip, country, uniq_id
And we need to make tons of querys looking for a particular ip on the database to get its country and we're asking some questions that may be you can help us to optimize the usage. How will you store the ip ranges on the database, bigint, char (hexadecimal, dotted format), how will you organize the indexes? how will you make the querys? Now we have indexed from_ip and to_ip, and looking for the ip on the database (converting it previously to int), but we're sure there is a more optimum way to do this. Thanks in advance for your help. Best, -- -------------------------------------------------------------------------- |Juan Enrique Gomez Perez | CEO & CTO |Metropoli2000 Networks, S.L. | Phone: +34 914250023 Fax: +34 914250136 | email: [EMAIL PROTECTED] -------------------------------------------------------------------------- PGP Fingerprint: 6B39 3A2B A17B 1E8E CFFD FC14 678E 0A22 BD80 C486 Public Key: http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xBD80C486 If this message hasn't a correct signature please notify it to [EMAIL PROTECTED] To get the public key please use the above url. Thanks for your help. -------------------------------------------------------------------------- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
