Em Andamento

Need programmer to resolve speed/reliability issues querying MySQL database

I run an adult blind clicks affiliate program. I use [url removed, login to view]'s Ultimate Advertiser affiliate pay-per-click script to handle the clickthru tracking and accounting. Ultimate Advertiser is perl, uses a MySQL database, and is on my dedicated unix server. My problem is that when I query the database it either takes a very long time to return results and often returns incomplete results. As the number of records in the database grows the problem gets worse. Currently I have only 700k records, I need to be able to run queries reliably with up to 100million records in the db. My hosting company's tech people reckon the database is designed inefficiently with tables not indexed, I don't know how true this is! From the scripts admin area I must be able to perform queries using the 'PAY ADVERTISERS' and 'EXPORT DATA TO TEXT FILE' functions, specifying any date range and any other available search criteria and get 100% complete and accurate results within a resonable time when the database's ppc_hits tables contains anything up to 100,000,000 records.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.

## Platform

Linux

Habilidades: Engenharia, Linux, MySQL, Perl, PHP, Arquitetura de software, Teste de Software, UNIX

Ver mais: true results, speed date script, range query, problem in accounting, php form search mysql database, php code search mysql database, mysql database software, mysql database server, i need programmer, i need a linux programmer, how to know accounting, click speed, how to be programmer, worse, ultimate database, speed up my, speed up data, reliability, programmer to programmer com, need programmer, linux software programmer, data to text file, affiliate programmer, mysql search area code, php script mysql export

Acerca do Empregador:
( 3 comentários ) United Kingdom

ID do Projeto: #2972847

Premiar a:

snathanhillbrand

See private message.

$85 USD em 30 dias
(5 Avaliações)
3.2

14 freelancers estão ofertando em média $172 para este trabalho

adyzah

See private message.

$127.5 USD in 30 dias
(91 Comentários)
7.3
bradaric

See private message.

$255 USD in 30 dias
(89 Comentários)
6.7
scriptclonervw

See private message.

$127.5 USD in 30 dias
(10 Comentários)
3.7
captainjoe

See private message.

$170 USD in 30 dias
(13 Comentários)
3.4
realperlguy

See private message.

$233.75 USD in 30 dias
(7 Comentários)
2.8
tsoftsolutions

See private message.

$255 USD in 30 dias
(1 Comentário)
1.1
ilya77

See private message.

$170 USD in 30 dias
(1 Comentário)
0.5
dragosbdivw

See private message.

$85 USD in 30 dias
(2 Comentários)
0.0
governor2003

See private message.

$212.5 USD in 30 dias
(0 Comentários)
0.0
angelonevw

See private message.

$170 USD in 30 dias
(2 Comentários)
2.1
thenetlogic

See private message.

$212.5 USD in 30 dias
(0 Comentários)
0.0
jolhoeft

See private message.

$212.5 USD in 30 dias
(0 Comentários)
0.0
sitethree

See private message.

$85 USD in 30 dias
(0 Comentários)
0.0