<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Tim,</p>
<p>Currently there is no guarantee that concurrent updates to the
same FileGDB database, either from the same process or from
different process, are safe, as no locks are set, and the driver
might cache in memory things assuming that nothing else changes
them behind its back.<br>
</p>
<p>That said, I *believe* (but definitely doesn't guarantee) that
you could create indexes on different layers/tables of a FileGDB
from concurrent ogrinfo instances. It is probably not safe however
to create indexes on different columns of the same table
concurrently, because the .gdbindexes file might be written
concurrently</p>
<p>Even<br>
</p>
<div class="moz-cite-prefix">Le 06/02/2023 à 12:03, Tim Martin via
gdal-dev a écrit :<br>
</div>
<blockquote type="cite"
cite="mid:LO4P123MB6563B435652CCA64F8D65A0685DA9@LO4P123MB6563.GBRP123.PROD.OUTLOOK.COM">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style>@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}div.WordSection1
{page:WordSection1;}</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal">Hi GDAL Devs<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I posted this question on GIS Stack
Exchange and someone recommended I contact this group (<a
href="https://gis.stackexchange.com/questions/451331/adding-multiple-attribute-indexes-to-filegdb-using-ogrinfo/451336#451336"
moz-do-not-send="true" class="moz-txt-link-freetext">https://gis.stackexchange.com/questions/451331/adding-multiple-attribute-indexes-to-filegdb-using-ogrinfo/451336#451336</a>)<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I have the unfortunate task of creating
some very large FileGDB and need to add multiple indexes to
several attributes on each Feature Type.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I saw that the OpenFileGDB driver under Dev
is now able to Write, so am using that version, which by my
testing is 3 or 4 times faster than the original FielGDB
driver – which is amazing!!!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Now I need to index these columns and it
has taken 26hrs to add 5 attribute indexes due to the sheer
number of features (200mill or so).<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">So am wondering if there is a way to use
ogrinfo and write indexes concurrently?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">With thanks Tim<o:p></o:p></p>
</div>
<br>
<br>
This email and any attachments are intended only for the intended
recipient and may contain sensitive information. If you are not
the intended recipient, please immediately delete this email and
inform the sender.<br>
<br>
OS email communications may be monitored to ensure the secure and
effective operation of our systems and for other lawful purposes.
Subject to contract: No rights are to be derived from any proposal
contained in this email until a written agreement containing all
necessary terms is executed between the relevant parties.<br>
<br>
Thank you for your cooperation.<br>
<br>
Ordnance Survey Limited (Company Registration number 09121572)<br>
Registered Office: Explorer House<br>
Adanac Drive<br>
Southampton SO16 0AS<br>
Tel: 03456 050505<br>
<a href="http://www.os.uk" moz-do-not-send="true"
class="moz-txt-link-freetext">http://www.os.uk</a>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
gdal-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/gdal-dev">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a>
</pre>
</blockquote>
<pre class="moz-signature" cols="72">--
<a class="moz-txt-link-freetext" href="http://www.spatialys.com">http://www.spatialys.com</a>
My software is free, but my time generally not.</pre>
</body>
</html>