php (group/join query) optimization

A **fully working** tracking system , needs 1 script **optimized** for the fastest SQL output on the database. Right now its working, but the script spawns too many uneffecient queries.

Project setup


- PHP 5

- mysql

The development scope


- 1 php script

- 1 mysql table

Data structure, log table


- ip : the incomming ip address

- date : current date NOW()

- time : current time NOW()

- time(h) : current hour

- host : incomming hostname

- url : incomming url

What do we want to see


- the total ammount of hits all time

- the total ammount of hits per day

- the total ammount of hits per day , per ip , per hour

- the total ammount of hosts in the last 7 days.

- last 250 hits of a day

Current un-optimized script


we got a test table filled with [url removed, login to view] records ready

(we can add more on request)

output : [url removed, login to view]

script : [url removed, login to view]

*what we want: 1 new fully working optimized php file.*

*optional : full ftp/mysql access possible.*

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):

a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

- apache server linux - php 5 - mysql

Habilidades: Amazon Web Services, Engenharia, Linux, MySQL, PHP, Arquitetura de software, Teste de Software

Veja mais: what data structure, what are data structure, web development per hour, the one group, table data structure, query of web development, php id, php development software linux, php coder 1.5, mysql query optimization software, hire bot coder, coder un web, code group, access group, the php group, query table, Query optimization, php software structure mysql, php and mysql web development, mysql linux php, Linux php, database optimization, data query, table optimization, php mysql join table

Acerca do Empregador:
( 1 comentário ) Netherlands

ID do Projeto: #3025849

Concedido a:


See private message.

$170 USD em 30 dias
(12 Comentários)

8 freelancers estão ofertando em média $329 para esse trabalho


See private message.

$127.5 USD in 30 dias
(90 Comentários)

See private message.

$425 USD in 30 dias
(138 Comentários)

See private message.

$425 USD in 30 dias
(62 Comentários)

See private message.

$212.5 USD in 30 dias
(19 Comentários)

See private message.

$425 USD in 30 dias
(19 Comentários)

See private message.

$425 USD in 30 dias
(29 Comentários)

See private message.

$425 USD in 30 dias
(4 Comentários)