Encerrado

need mysql optimization help

The following query takes approx. 2 seconds to run,

sometimes even longer.

select count(distinct md5sum) from directfreight.all_loads where (latitude1 * latitude1 * 4761 - [url removed, login to view]*latitude1 + longitude1 * longitude1 * 3025 - [url removed, login to view]*longitude1 < [url removed, login to view]);

I need to decrease this time to under .5 seconds

using whatever means possible. i.e. ramdrive,

more ram, faster processor, changes in mysql

settings, etc...

The link below is the output of a few basic

commands, if more information is needed,

please let me know.

[url removed, login to view]

Thanks,

Jon.

## Deliverables

optimal mysql variable settings.

optimal mysql indexes and syntax.

optimal hardware configuration, if applicable.

## Platform

linux

mysql

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

Ver mais: link optimization, query optimization, mysql select platform, mysql variable help, variable mysql, need seconds, hardware using php, mysql query optimization, need faster, mysql output, mysql php output, hardware linux, approx seconds, count mysql, linux hardware, php mysql count, select count php, php select optimization, php optimal, php linux optimization, linux processor count, linux count time, mysql variable php, mysql run query, distinct mysql

Acerca do Empregador:
( 50 comentários ) Chillicothe, United States

ID do Projeto: #3012131

7 freelancers estão ofertando em média $39 para este trabalho

bradaric

See private message.

$85 USD in 7 dias
(89 Comentários)
6.7
roystervw

See private message.

$68 USD in 7 dias
(32 Comentários)
5.1
thecodebuyer

See private message.

$68 USD in 7 dias
(24 Comentários)
4.6
felenkavw

See private message.

$12.75 USD in 7 dias
(26 Comentários)
3.4
firmwarevw

See private message.

$8.5 USD in 7 dias
(1 Comentário)
0.7
gmarkvw

See private message.

$8.5 USD in 7 dias
(0 Comentários)
0.0
sqlr

See private message.

$21.25 USD in 7 dias
(0 Comentários)
0.0