duckdb_spatial icon indicating copy to clipboard operation
duckdb_spatial copied to clipboard

Avoid scanning entire Geodatabase file

Open marklit opened this issue 1 year ago • 7 comments

It appears an entire scan of a Geodatabase file is needed before a single record can be returned. The following pulls one record from an 870 MB file and takes ~36 seconds to do so.

select FIPS_CODE FROM st_read('SF_Professional_AK.gdb/a00000011.gdbtable') LIMIT 1;
┌───────────┐
│ FIPS_CODE │
│  varchar  │
├───────────┤
│ 11111     │
└───────────┘
Run Time (s): real 36.234 user 33.853635 sys 2.386451

marklit avatar May 04 '23 12:05 marklit