i want to get city of currunct user by passing IP address.i have GeoLiteCity.DAT file having all world data.
This works fine.The issue is it takes a lot of time from like more than 50 seconds....can i do anything like indexing or anything so that we can improve speed?
The best thing would be to put it into a datbase such as sql server and index the ipaddress columns. Sql server can do these lookups much faster than just by querying a .dat file.
Don't forget to mark useful responses as Answer if they helped you towards a solution.
The best thing would be to put it into a datbase such as sql server and index the ipaddress columns. Sql server can do these lookups much faster than just by querying a .dat file.
how can i put/save in sqlserver?it have alot of data....is it possible through a machine or query or software etc etc?
You may want to ask that question in a topic group about Sql Server.
Superguppie.
Please remember to click “Mark as Answer” on the post that helps you. This can be beneficial to other community members reading the thread.
When all you've got is a Hammer, Every Problem looks like a Nail. Michael Swain.
Marked as answer by shafiqkr on May 22, 2012 06:24 AM
shafiqkr
Member
454 Points
372 Posts
GeoLiteCity Issue
May 17, 2012 08:38 AM|LINK
Hi,
i want to get city of currunct user by passing IP address.i have GeoLiteCity.DAT file having all world data.
This works fine.The issue is it takes a lot of time from like more than 50 seconds....can i do anything like indexing or anything so that we can improve speed?
markfitzme
Star
14495 Points
2243 Posts
Re: GeoLiteCity Issue
May 17, 2012 12:57 PM|LINK
The best thing would be to put it into a datbase such as sql server and index the ipaddress columns. Sql server can do these lookups much faster than just by querying a .dat file.
shafiqkr
Member
454 Points
372 Posts
Re: GeoLiteCity Issue
May 17, 2012 01:55 PM|LINK
how can i put/save in sqlserver?it have alot of data....is it possible through a machine or query or software etc etc?
superguppie
All-Star
48225 Points
8679 Posts
Re: GeoLiteCity Issue
May 21, 2012 11:33 AM|LINK
You may want to ask that question in a topic group about Sql Server.
Please remember to click “Mark as Answer” on the post that helps you. This can be beneficial to other community members reading the thread.
When all you've got is a Hammer, Every Problem looks like a Nail. Michael Swain.