Terminé

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

Compétences : Ingénierie, Linux, MySQL, Perl, PHP, Architecture Logicielle, Tests de Logiciels, UNIX

en voir plus : 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

Concernant l'employeur :
( 3 commentaires ) United Kingdom

Nº du projet : #2972847

Décerné à:

snathanhillbrand

See private message.

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 30 jours
(5 Commentaires)
3.2

14 freelance font une offre moyenne de $172 pour ce travail

adyzah

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(91 Commentaires)
7.3
bradaric

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(89 Commentaires)
6.7
scriptclonervw

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(10 Commentaires)
3.7
captainjoe

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(13 Commentaires)
3.4
realperlguy

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(7 Commentaires)
2.8
tsoftsolutions

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(1 Évaluation)
1.1
ilya77

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(1 Évaluation)
0.5
dragosbdivw

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(2 Commentaires)
0.0
governor2003

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(0 Commentaires)
0.0
angelonevw

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(2 Commentaires)
2.1
thenetlogic

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(0 Commentaires)
0.0
jolhoeft

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(0 Commentaires)
0.0
sitethree

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(0 Commentaires)
0.0