Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: open
I am working with GEO IP Database(MSSQL) at this point and would like to make some queries a bit faster.
The entire DB is over 100000 records and we look up the country by comparing IP to the Database on every request.
Would it make a difference if we split the MASTER IP Table of DB in 255 tables and compare first octet of incoming IP to a particular Table accordingly, would it make any difference if they were views. Any other recommendations would be welcome.
Just from your experience.
single threaded operation with multithreaded libs
@ 550 mhz:
400 million geoip lookups on 4 billion ip address
space takes 31 seconds, or 12,903,225 per second
Put it this way: the geoip overhead of processing a log file with 13 million hits in it would be about 1 second.
My db is at the country/region level.
That way the result set is fetched direct from the index not touching the database and it really improves lookup times.
BTW, when using TOP Keyword does the DB Engine stops after it finds the first match or it still goes thru the rest of the rows?