<div dir="ltr"><div>Thanks Weston for <a href="https://github.com/OSGeo/PROJ/pull/4833">https://github.com/OSGeo/PROJ/pull/4833</a></div><div>It will be in PROJ 9.9.0!</div><div><br></div><div>For the people using auxiliary dbs (I know there is some people in this list. Unfortunately I forgot their names), this is a great improvement.</div></div><br><div class="gmail_quote gmail_quote_container"><div dir="ltr" class="gmail_attr">On Mon, 31 Aug 2026 at 22:43, Even Rouault via PROJ <<a href="mailto:proj@lists.osgeo.org">proj@lists.osgeo.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><u></u>
<div>
<p><br>
</p>
<div>Le 31/08/2026 à 22:34, Weston Renoud a
écrit :<br>
</div>
<blockquote type="cite">
<div style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
Hey Even,</div>
<div style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif;font-size:12pt">
<span style="color:rgb(0,0,0)">Removing the ORDER BY clause
removed the need to materialize and gives the same query
performance as with the temporary tables, but without the need
to create any temporary tables which took extra time. Adding
back just the "</span><span style="color:black">ORDER BY </span><span style="color:rgb(0,0,0)">score" still avoided the
materialize, it seemed to be the "</span><span style="color:black">usage.auth_name, usage.code" that
triggered the materialize. Are those necessary, or is "ORDER
BY score" sufficient?</span></div>
</blockquote>
<p>They are only necessary for reproducibility of results among
SQLite versions, in case of equality of score. There is no
guarantee otherwise that different SQLite versions would return
the same ordered result set. So they would need to be replicated
on the C++ side ( <a>std::sort()</a> with an appropriate sort lambda)</p>
<pre cols="72">--
<a href="http://www.spatialys.com" target="_blank">http://www.spatialys.com</a>
My software is free, but my time generally not.
LLMs contribute to global warming and brain rot.
Let's guillotine them! "Ah ! ça ira, ça ira, ça ira !"</pre>
</div>
_______________________________________________<br>
PROJ mailing list<br>
<a href="mailto:PROJ@lists.osgeo.org" target="_blank">PROJ@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/proj" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/proj</a><br>
</blockquote></div>