--box parameter takes forever on large table

[bertt]

Hi,

I was running Roofer with --box parameter on a large footprint table, but it takes forever as the specified box
is not used when getting the layer extent in https://github.com/3DBAG/roofer/blob/develop/src/extra/io/VectorReaderOGR.cpp#L175

Query executed:

SELECT ST_Extent("geom") FROM mytable AS ogrpgextent

I guess the box should be used in this query.

[Ylannl]

Do you have a spatial index on geom here?

[bertt]

yes but it does not help with this query (all the geometries needs to be scanned)