Mysql count hits Statistics


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

Skills: MariaDB, MySQL, PHP

See more: count mysql slow php, vote count mysql php, joomla hits count, php select count mysql, slow fast count count mysql, dont hits count joomla, distinctrow count mysql, perl code example count mysql, coldfusion count number words, convert access count mysql, select count mysql php, count mysql query tree, onclick count mysql database, count textarea words, php mysql words language, count 350 words, php count chinese words, count mysql php, record count mysql database several table vb6, php count certain words

About the Employer:
( 13 reviews ) Mayaguez, Puerto Rico

Project ID: #11726824

Awarded to:


Hi musarano, I can start anytime. Also I have more than 4 years experience working with MySQL (and MariaDB), query performance optimizations and PHP so I am sure I will prove to be an excellent developer and complete More

$55 USD in 3 days
(48 Reviews)

13 freelancers are bidding on average $66 for this job


Hi, I am joomla, virtuemart expert having 5 years of experience. Recently i completed these projects [login to view URL] [login to view URL] [login to view URL] Please award me the project.

$35 USD in 3 days
(274 Reviews)

can we start sir.....can we start sir.....can we start sir.....can we start sir.....can we start sir.....can we start sir.....

$30 USD in 3 days
(168 Reviews)

Hi, we are understand your requirement . we have 5 + year experience in design & development so communicate with me . you can check my work on below URL: PHP web URL : [login to view URL] http://sgcityj More

$50 USD in 3 days
(37 Reviews)

Message me before you gonna award this project to me Message me before you gonna award this project to me Message me before you gonna award this project to me Message me before you gonna award this project to me Me More

$50 USD in 3 days
(55 Reviews)

Hi there - My name is Jhalak. I’ve read your brief and can see that you’d like to build an [login to view URL] team has 4 years experience designing and developing mobile apps and Websites as well as SEO.I would approach your p More

$72 USD in 3 days
(78 Reviews)

We will build the counter script and integrate it to your website as according to your requirement . We build simple to big Online Stores ,complex Billing Management System , Order management System , Inventory or More

$58 USD in 1 day
(16 Reviews)

Hi, I have gone through your project requirement. I can do this project and start working on your project from right now. We as a MarlinByte Software Solutions team is expert in PHP technology, Wordpress and hav More

$100 USD in 2 days
(7 Reviews)

A proposal has not yet been provided

$66 USD in 3 days
(4 Reviews)
$58 USD in 3 days
(25 Reviews)

Hello sir, we are professional web designers and developers and can provide quality work to you if you allows us to serve you.

$77 USD in 3 days
(7 Reviews)

Hello Sir..! I read your description I can complete your project on time and within your budget I am fully confident about your project. I will receive your best wishes. I am waiting your response thanks you so much More

$100 USD in 3 days
(9 Reviews)

Hello, I have read your project description; I have few questions to ask. I am a WordPress certified developer. I can offer you high level of professionalism, great command of PHP, CakePHP, HTML5, CSS, JavaScript, CRM, More

$111 USD in 5 days
(13 Reviews)
$50 USD in 0 days
(0 Reviews)