How do I use Spatialite400.dll?

Question

Hi -

I was pleased to find "C:\Program Files\ArcGIS\Pro\bin\spatialite400x.dll".  (I wasn't expecting it since there's no mention of spatialite in Esri's 3rd Party Acknowledgements doc.)

I'm able to load it as an extension in Db Browser; however, the spatialite polygon queries all seem to return null.

Am I doing something wrong?

Thanks, Kirk

MarcoBoeringa · Answer

The Pairwise Dissolve tool is actually just running on a modest 4C/8T Core i7 desktop (32GB RAM though). And I only set the geoprocessing environment to allow 75% 3C/6T usage of the processor, so as to not completely consume this limited CPU.

The database is running on a HP Z840 workstation though, a refurbished one that I recently acquired, and has dual Xeon E5-2680 v4 with 14C/28T each, so 28C/56T total.

This is some custom Python multi-threaded code I developed (unrelated to the SQLite stuff), that goes flat out at 100% usage on the database server generalizing geometries in PostGIS:

KirkKuykendall1 · Answer

Wow.

I fear the "lite" in Sqlite may have led people to think it can't do any heavy lifting.

How many cores is Pairwise_Dissolve using?

MarcoBoeringa · Answer

Thought you might like this as well, ArcGIS Pro's Pairwise Dissolve tool dissolving a 379 M(!) record dataset of building geometries...