Need programmer to resolve speed/reliability issues querying MySQL database

Completed Posted Sep 10, 2003 Paid on delivery
Completed Paid on delivery

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

Engineering Linux MySQL Perl PHP Software Architecture Software Testing UNIX

Project ID: #2972847

About the project

14 proposals Remote project Active Sep 16, 2003

Awarded to:

snathanhillbrand

See private message.

$85 USD in 30 days
(5 Reviews)
3.2

14 freelancers are bidding on average $172 for this job

adyzah

See private message.

$127.5 USD in 30 days
(91 Reviews)
7.3
bradaric

See private message.

$255 USD in 30 days
(89 Reviews)
6.7
scriptclonervw

See private message.

$127.5 USD in 30 days
(10 Reviews)
3.7
captainjoe

See private message.

$170 USD in 30 days
(13 Reviews)
3.4
realperlguy

See private message.

$233.75 USD in 30 days
(7 Reviews)
2.8
tsoftsolutions

See private message.

$255 USD in 30 days
(1 Review)
1.1
ilya77

See private message.

$170 USD in 30 days
(1 Review)
0.5
dragosbdivw

See private message.

$85 USD in 30 days
(2 Reviews)
0.0
governor2003

See private message.

$212.5 USD in 30 days
(0 Reviews)
0.0
angelonevw

See private message.

$170 USD in 30 days
(2 Reviews)
2.1
thenetlogic

See private message.

$212.5 USD in 30 days
(0 Reviews)
0.0
jolhoeft

See private message.

$212.5 USD in 30 days
(0 Reviews)
0.0
sitethree

See private message.

$85 USD in 30 days
(0 Reviews)
0.0