Need programmer to resolve speed/reliability issues querying MySQL database
$100-300 USD
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
Project ID: #2972847