Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
find IP among 1.5mill records
I've never created indexes before, are you able to explain to me how I do this? Regards, Sero -
find IP among 1.5mill records
The complete table definition: create table IPCITYLATLONG( ipFROM int(10) unsigned zerofill NOT NULL DEFAULT 0000000000 , ipTO int(10) unsigned zerofill NOT NULL DEFAULT 0000000000 , countrySHORT char(2) NOT NULL , countryLONG varchar(64) NOT NULL , ipREGION varchar(128) NOT NULL , ipCITY... -
find IP among 1.5mill records
Hi, I have recently purchased the ip2location database. This databse containts 1.5million rows with IP ranges (ipFROM,ipTO) and some other data like countryname, cityname etc. I need to write a query that is extremely much faster than my current ones. The IP numbers are stored in long format...
