<!DOCTYPE html><html><head><title></title><style type="text/css">
p.MsoNormal,p.MsoNoSpacing{margin:0}</style></head><body><div>Hi Rob,<br></div><div><br></div><div>Are you using the same MapServer machine to make the queries?<br></div><div>If the MapServer version, and dependencies are all identical then the generated SQL queries should also be identical.<br></div><div>You wrote about "hitting the web page" - but if the requested extents are different then it is likely the client requests are different. Are you using WMS services? What do these requests look like?<br></div><div>Also you mention 4 different layers, so I'd try testing them one by one - are they all generating different SQL and response times?<br></div><div><br></div><div>Seth<br></div><div><br></div><div id="sig62266145"><div class="signature">--<br></div><div class="signature">web:<a href="https://geographika.net">https://geographika.net</a> & <a href="https://mapserverstudio.net">https://mapserverstudio.net</a><br></div><div class="signature">twitter: @geographika<br></div></div><div><br></div><div>On Tue, Feb 6, 2024, at 8:53 PM, Rob Dennett via MapServer-users wrote:<br></div><blockquote type="cite" id="qt" style=""><div class="qt-elementToProof" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;font-size:12pt;color:rgb(0, 0, 0);">Both DBs are hosted on AWS Aurora. The old one is serverless v1 and the new one is serverless v2. We were thinking that perhaps the geom column for my table needed a spatial index even though the old db doesn't have one. Is that possible? Also, would it
make sense that the same query run on both should take the same amount of time (roughly)?<br></div><div class="qt-elementToProof" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;font-size:12pt;color:rgb(0, 0, 0);"><br></div><div class="qt-elementToProof" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;font-size:12pt;color:rgb(0, 0, 0);">Thanks,<br></div><div class="qt-elementToProof" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;font-size:12pt;color:rgb(0, 0, 0);">Rob<br></div><div style="background-color:rgb(255, 255, 255);border-top-width:2pt;border-right-width:2pt;border-bottom-width:2pt;border-left-width:2pt;border-top-style:solid;border-right-style:solid;border-bottom-style:solid;border-left-style:solid;border-top-color:rgb(244, 58, 19);border-right-color:rgb(244, 58, 19);border-bottom-color:rgb(244, 58, 19);border-left-color:rgb(244, 58, 19);"><br></div><div style="padding-top:3pt;padding-right:0cm;padding-bottom:0cm;padding-left:0cm;border-top-width:1pt;border-top-style:solid;border-top-color:rgb(225, 225, 225);"><br></div><div align="center" style="margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:0cm;"><br></div><div style="padding-top:0cm;padding-right:0cm;padding-bottom:0cm;padding-left:0cm;border-top-width:2.25pt;border-right-width:2.25pt;border-bottom-width:2.25pt;border-left-width:2.25pt;border-top-style:solid;border-right-style:solid;border-bottom-style:solid;border-left-style:solid;border-top-color:rgb(244, 58, 19);border-right-color:rgb(244, 58, 19);border-bottom-color:rgb(244, 58, 19);border-left-color:rgb(244, 58, 19);"><br></div><div>_______________________________________________<br></div><div>MapServer-users mailing list<br></div><div><a href="mailto:MapServer-users@lists.osgeo.org">MapServer-users@lists.osgeo.org</a><br></div><div><a href="https://lists.osgeo.org/mailman/listinfo/mapserver-users">https://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br></div><div><br></div></blockquote><div><br></div></body></html>