I have ip converted in float like this:

1362268423

3476946705

1179659265

1179726082

3234155789

3254497794

3489515534

3567080704

1390476300

1390490892

1390832915

1415938309

1456668932

3258127372

3569568532

3573210393

I have to check in a lookup table (containing more than 2M rows) set up like this:

ipFrom                 ipTo                   countryId

---------------------- ---------------------- -----------

0                      33996343               95

33996344               33996351               219

33996352               50331647               95

50331648               50331903               220

50331904               50332159               220

50332160               50332671               220

50332672               50332927               220

50332928               50333695               220

50333696               50333951               220

50333952               50334719               220

So the #regions would look like this after:

ipFloat                countryId

---------------------- -----------

1362268423             70

3476946705             38

1179659265             38

1179726082             38

3234155789             38

3254497794             70

3489515534             38

3567080704             199

1390476300             70

1390490892             70

thanks

Stephane