I am having performance issues looking up streets. Is it possible to create indexes on the dbf files?
I’m not sure. We’re using an external library for reading/writing shapefiles.
If that library can handle it, MWGis should be able to handle it as well.
@jerryfaust, you’ve recently updated the shapefile library. Do you know if this is possible?
I poked around a little, and unfortunately, I don’t see any references to dBase indexes (ndx or mdx) in the library.
I know that it may not be practical, but if you have an OGR-supported database engine available (or even create a SQLite database), you could upload the shapefile there. I’ve done this in the past, and you can then get much more efficient query capabilities.
Thanks. I did add the Microsoft Jet odbc and can query the .dbf file directly, which seems to work fine and I am getting pretty good performance now both ways. It looks like I am geocoding about 10 addresses per second, which looks like it will be fast enough. Thanks for all the help.
This topic was automatically closed after 4 days. New replies are no longer allowed.