You can import GeoLite City database into MySQL as well. GeoLite's binary database appears to be very fast, the best generic MySQL solution for fetching location by IP I've come up with was 2-3 times slower than their binary database (using MyISAM, query cache was off).
But for more specific cases (IPs coming from database, in huge amounts, for example), in theory, it's possible to make MySQL perform better by making use of a single query for mass-lookup. 2007/8/7, Fran Simó <[EMAIL PROTECTED]>: > > > In the Bakery I found this > http://bakery.cakephp.org/articles/view/quickly-translate-ip-to-geo-coordinates > After making my own code based on http://www.hostip.info/dl/index.html > within mySQL. :( > > GeoLite City seems to be more accurate than hostip.info. In the other > hand GeoLite uses direct access to disk which I presume is slower than > mysql indexed tables. > > Is someone using some of this options? Any thoughts? > > Thanks. > > > > > -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
