SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Wizard
    Join Date
    Oct 2004
    Location
    Newport Beach
    Posts
    1,761
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    GeoIP Service - Does It Use Lots of Resources

    I was considering installing the PHP GeoIP Service onto my primary web server. This service will likely get about 400K requests per day (as I attempt to find the country location of each visitor).

    My question is, this the best way to go about it? Will the resource usage doing it this way sink the web server (which is already under some duress)? Any other options you recommend?

    I'm doing it to decide if a person is in Canada and, if they are, give them a separate Ad Tag.

    All feedback appreciated!
    Cheers!
    Ryan
    Upcoming Movies - Movie News. Updated Daily.
    Movie Trailers - Awesome trailer site. Nuff said.

  2. #2
    Keeper of the SFL StarLion's Avatar
    Join Date
    Feb 2006
    Location
    Atlanta, GA, USA
    Posts
    3,748
    Mentioned
    72 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by casbboy View Post
    I was considering installing the PHP GeoIP Service onto my primary web server. This service will likely get about 400K requests per day (as I attempt to find the country location of each visitor).

    My question is, this the best way to go about it? Will the resource usage doing it this way sink the web server (which is already under some duress)? Any other options you recommend?

    I'm doing it to decide if a person is in Canada and, if they are, give them a separate Ad Tag.

    All feedback appreciated!
    Cheers!
    Ryan
    Should be fairly light resource usage...Essentially, what geoIP does is download a massive CSV file containing IP range -> country pairings every so often, and when you ask for geoip_country, it does a flat-file-database style equivalent of 'SELECT country WHERE startint <= ip AND endint >= ip (it stores both dotted notation and integer conversion forms of the IP range data)
    Never grow up. The instant you do, you lose all ability to imagine great things, for fear of reality crashing in.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •