<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Hi Guys,<div><br></div><div>I appreciate there are optimization tips on the website, however I wondered if there are any specific tips for optimization when dealing with a records table or associated view of 500K rows in a Mysql backend database on a Virtual Centos Machine with 2 x 3Ghz processors, 1GB RAM and 20GB Memory.</div><div><br></div><div>I am seeing some slow responses in terms of using dig to perform NAPTR record lookups.</div><div><br></div><div>Any help would be great.</div><div><br></div><div>Many thanks</div><div><br></div><div>Jon</div> </div></body>
</html>