The following query takes approx. 2 seconds to run,
sometimes even longer.
select count(distinct md5sum) from directfreight.all_loads where (latitude1 * latitude1 * 4761 - 367834.870171*latitude1 + longitude1 * longitude1 * 3025 - 545709.981537*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
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]
optimal mysql variable settings.
optimal mysql indexes and syntax.
optimal hardware configuration, if applicable.