Mysql count hits Statistics

This project was successfully completed by mvladt for $55 USD in 3 days.

Get free quotes for a project like this
Project Budget
$30 - $75 USD
Completed In
3 days
Total Bids
Project Description


I need a very fast algorithm to keep track on connection been made to channel.

Each channel will be dinamicly created if it doenst exist.

It will contains:

Channel: Country-name, Total-Visits by country (a day [based on date of hit] )

If an IP already visited that Channel on same day, it will count++ as another Hit for that Channel, but not count as another Visit.

In other words, the following visitis from same IP will count as a Hit for that day/date

I will pass the parameters ( IP, Channel, Country )

I will then need, the mysql DB with its tables and definitions in an SQL file to be easily created from mysql import or so.

We can then test the feature before completition.

-Please, i need the DB to be very fast (indexes or filters)

Thank You

Completed by:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online