Here is what you need to do: 1 - download the

Question

Пользователь 61930

Here is what you need to do: 1 - download the

geo-lite database
2- load it all into memory
3- make a b tree out of all the ranges available.

4- now you have an ip in your own database that want to know which country it belongs to right? So, lookup that IP in the b tree you create. Whichever range it matched on. Lookup the country for that range.

Now you know which country a given IP belongs to.

You can do whatever you want with that information in your original database

#english #programming

0

16.10.2020

11 ответов

14 просмотров

Пользователь 61930 Автор вопроса

Kazem
Looks good I want t know which countries have most...

Same thing. Only you need some sort of map. You will lookup each ip in the b tree Then creat a map like {"Iran": 1} If you find another user form iran do Users["iran"] +1

0

16.10.2020

Пользователь 61930 Автор вопроса

Kazem
Looks good I want t know which countries have most...

What language are you using for your project? geoip-lite might be available for your language.

0

16.10.2020

Kazem

Пользователь 61930
Same thing. Only you need some sort of map. You ...

Takes tooo long 😐 if user needs to use online mode takes more time

0

16.10.2020

Пользователь 61930 Автор вопроса

Kazem
Takes tooo long 😐 if user needs to use online mode...

No it doesn't you're doing something that it just happens that I have done before. If you load geoip-lite into memory it takes up to 15sec but it's a one time cost. Then lookups are really fast in b tree. Like I'm talking 9ms response.

0

16.10.2020

Kazem

Пользователь 61930
No it doesn't you're doing something that it just ...

I use that feature in index page :D

0

16.10.2020

Пользователь 61930 Автор вопроса

Kazem
I use that feature in index page :D

What are you exactly trying to do?

0

16.10.2020