Thanks for the tips Laurențiu. <div><br></div><div>O zi faină, </div><div>Robert Nagy <br><div><div><br><div id="ymail_android_signature"><a id="ymail_android_signature_link" href="https://mail.onelink.me/107872968?pid=nativeplacement&c=Global_Acquisition_YMktg_315_Internal_EmailSignature&af_sub1=Acquisition&af_sub2=Global_YMktg&af_sub3=&af_sub4=100000604&af_sub5=EmailSignature__Static_">Sent from Yahoo Mail on Android</a></div> <br> <blockquote style="margin: 0 0 20px 0;"> <div style="font-family:Roboto, sans-serif; color:#6D00F6;"> <div>On Wed, Jan 17, 2024 at 3:34 PM, Laurențiu Nicola</div><div><lnicola@dend.ro> wrote:</div> </div> <div style="padding: 10px 0 0 20px; margin: 10px 0 0 0; border-left: 1px solid #6D00F6;"> <div id="yiv9949969310"><title></title><div><div style="font-family:Arial;">A pipe might prevent you from creating a spatial index, right?<br clear="none"></div><div style="font-family:Arial;"><br clear="none"></div><div style="font-family:Arial;">I didn't test it, but another method would be to use a join (you can query multiple data sources in the same ogr2ogr invocation, <a rel="nofollow noopener noreferrer" shape="rect" target="_blank" href="https://gdal.org/user/ogr_sql_dialect.html#joins">https://gdal.org/user/ogr_sql_dialect.html#joins</a>), but they are pretty limited and you might lose the spatial index.<br clear="none"></div><div style="font-family:Arial;"><br clear="none"></div><div style="font-family:Arial;">If you just want to make it faster, <a rel="nofollow noopener noreferrer" shape="rect" target="_blank" href="https://gdal.org/drivers/vector/sqlite.html#target-drivers-vector-sqlite-performance-hints">https://gdal.org/drivers/vector/sqlite.html#target-drivers-vector-sqlite-performance-hints</a> can also be pretty useful.<br clear="none"></div><div style="font-family:Arial;"><br clear="none"></div><div style="font-family:Arial;">Laurentiu<br clear="none"></div><div style="font-family:Arial;"><br clear="none"></div><div id="yiv9949969310yqtfd08086" class="yiv9949969310yqt4400871241"><div>On Wed, Jan 17, 2024, at 15:51, <a rel="nofollow noopener noreferrer" shape="rect" ymailto="mailto:nagyrobi_r@yahoo.com" target="_blank" href="mailto:nagyrobi_r@yahoo.com">nagyrobi_r@yahoo.com</a> wrote:<br clear="none"></div><blockquote id="yiv9949969310qt" type="cite" style=""><div>Technically in want to save time by not saving to disk. That is one of the main reasons that i want to save in memory. <br clear="none"></div><div>I tried chaning them using pipes but didnt work. <br clear="none"></div><div><br clear="none"></div><div>Cu respect, <br clear="none"></div><div><div>Robert Nagy<br clear="none"></div></div></blockquote><div style="font-family:Arial;"><br clear="none"></div></div></div></div> </div> </blockquote></div></div></div>