0

I need to use the geoip data files from Maxmind and I want to know which is faster:

  • Import CSV into a mysql database (about 60 Mb) and query it
  • Use the binary .DAT files (18 Mb) and the corresponding PHP API
ali
  • 10,927
  • 20
  • 89
  • 138
  • 1
    did you run a benchmark? – Funk Forty Niner Jun 08 '15 at 14:02
  • I only tried the MySQL alternative, which is quite slow. Testing the .DAT + API option now. I hoped somebody already found the best one – ali Jun 08 '15 at 14:04
  • php.net generally speaks about getting it from a dat file so I would assume that. Though it depends where you want to run it, what the storage/memory/cache is like on each? I assume you want to know which is faster because you expect much of a difference between them? If speed is your thing you could offload the GEOIP'ing to varnish or something also. – Matt The Ninja Jun 08 '15 at 14:14

0 Answers0