Em Andamento

PHP/Perl/MySQL : Optimization Job

Our company provides Dialer Solutions to Clients, to promote onto their website.

To know how much each customer earned we utilize an Statistical System which is build in PHP heavily using Mysql.

Due to too much expensation the last months the system is not able to handle the amount at all anymore.

Our Account (that lists all accounts under us) takes usually 9-12 Minutes to load, and we expect this to get even worse in the future (with the more records that are into the database)

The System itself combines Account information with Statistics records, together with rates that are assigned to each Stats Record. (All dynamically with each run) - Which multiplies very fast!

We use an Affiliate Sheme, with a total of 4 levels where each Level gets different rates (more payout or less) - so it is not possible to do write this information static into the database.

What we need is someone with extensive Knowledge about Database System and PHP,Perl.

We are looking forward to :

1) Having the code optimized, partly rewritten, so the query time of now 12 minutes falls back to 10-20 Seconds only. But with the same functionality. We are already using indexes within the database to improve query time, but this was not enough. If this goal can not be reached - then any work done is useless to use, and due an arbitation we will request all money back.

2) After you have improved the speed of the system you know your way through the script, and future works like improvments, adding of features will be done by you. But this will not be discussed within this bid.

Ps.: We currently run the Script onto a Dual-Pentium with 1 Gig Ram - of course we can not buy a new server to improve speed, as the current one has already more power than most hosting companies offer.

Requests from serious, very well experienced coders, database architecture experts are extremly appreciated. Everyone who has not at leat 5 years experience in this sector, please save your time writting.

Thank you,

efp

## 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) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).

## Platform

FreeBsd, MySql, PHP, Perl

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

Ver mais: job get, fast hosting, perl get, mysql query optimization software, mysql gpl, mysql database buy, mysql customer database, more gig, companies use php, hosting job, gpl mysql, gig site, gig buy, experts solutions, like job, customer writting, current job, copyright job, company build mysql database, coders job, coders need job, buy gig, buy coders, build mysql query, affiliate job

Acerca do Empregador:
( 51 comentários )

ID do Projeto: #2998756

Premiar a:

roystervw

See private message.

$425 USD em 20 dias
(32 Avaliações)
5.1

13 freelancers estão ofertando em média $607 para este trabalho

cinterosystems

See private message.

$425 USD in 20 dias
(139 Comentários)
5.6
snakebytero

See private message.

$637.5 USD in 20 dias
(10 Comentários)
4.7
inetalex

See private message.

$425 USD in 20 dias
(18 Comentários)
4.6
phvw

See private message.

$595 USD in 20 dias
(3 Comentários)
4.2
judithkelley

See private message.

$510 USD in 20 dias
(7 Comentários)
3.7
aimhightech

See private message.

$425 USD in 20 dias
(3 Comentários)
3.3
superpedro

See private message.

$850 USD in 20 dias
(6 Comentários)
3.7
fernandocerini

See private message.

$663 USD in 20 dias
(0 Comentários)
0.0
tracker123

See private message.

$765 USD in 20 dias
(0 Comentários)
0.0
softfactoryvw

See private message.

$510 USD in 20 dias
(1 Comentário)
0.0
ramajanavw

See private message.

$595 USD in 20 dias
(0 Comentários)
0.0
vw933992vw

See private message.

$1062.5 USD in 20 dias
(2 Comentários)
0.0