Em Andamento

PHP/MySQL optimization

Analyze PHP page and outline why it takes approx 20 seconds to parse.

Here is the work I have already done:

I have used getmicrotime() throughout the script to try to identify the areas taking a long time to execute. My MySQL queries are not the problem, they are all fast. I have limited the possible area to one while() loop, which iterates about a dozen times. The strange part is that sometimes this entire loop takes only 1-2 ms to execute, sometimes it takes up to 2 seconds! When I refresh the page, the time it takes for the loop iteration to execute changes -- it is never the same. So I don't think it is anything in the code -- maybe it is a performance flaw in the server? In any case, even though the while() loop is nearly random in how long it takes, the entire script is fairly contant at 17-19 seconds to execute.

My server load is never higher than about 5%, so it is not a lack of ability of the server. The server is a dual [url removed, login to view] Xeon with [url removed, login to view] interleaved DDR memory.

## Deliverables

1) Explanation of long parse time and detailed optimization solution

## Platform

Redhat 9.0, PHP 4.2.2, MySQL [url removed, login to view]

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

Ver mais: strange engineering, ddr, mysql performance optimization, mysql memory load, php script execute, php page load, dual php, execute seconds, iteration, mysql server performance, php server optimization, performance engineering, page load optimization, php redhat, 5gb, php mysql script changes, php server load mysql, load optimization, php mysql load time, solution optimization, load php mysql, performance optimization, php code refresh, optimization problem, approx seconds

Acerca do Empregador:
( 5 comentários ) United States

ID do Projeto: #3055647

Premiar a:

stanishjohnd

See private message.

$25.5 USD em 2 dias
(44 Avaliações)
4.3

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

TakeRealUK

See private message.

$17 USD in 2 dias
(551 Comentários)
6.7
AndrwProjects

See private message.

$25.5 USD in 2 dias
(198 Comentários)
6.5
silkroutesl

See private message.

$25.5 USD in 2 dias
(126 Comentários)
6.6
inguza

See private message.

$17 USD in 2 dias
(22 Comentários)
5.7
bukhtik

See private message.

$25.5 USD in 2 dias
(22 Comentários)
5.1
solutiiit

See private message.

$10.2 USD in 2 dias
(10 Comentários)
3.9
rpasay

See private message.

$17 USD in 2 dias
(12 Comentários)
3.2
aus1vw

See private message.

$12.75 USD in 2 dias
(5 Comentários)
3.1
gyorgyati

See private message.

$12.75 USD in 2 dias
(12 Comentários)
3.4
eyenetsolut

See private message.

$25.5 USD in 2 dias
(14 Comentários)
2.5
bwsolutionsvw

See private message.

$25.5 USD in 2 dias
(3 Comentários)
1.6
vw809288vw

See private message.

$25.5 USD in 2 dias
(0 Comentários)
0.0
chsh

See private message.

$17 USD in 2 dias
(0 Comentários)
0.0
guelder

See private message.

$12.75 USD in 2 dias
(1 Comentário)
0.0