Hopefully have an interesting Friday question that I would be very grateful for your help on.
We are using a feature reader to read all the features/tables in a PostGIS database contained within a particular schema. There are lots of tables/features and when they write to the Filegeodatabase Open API writer for some reason we get locking issues after approximately 400 tables (sometimes more sometimes less) we can write out to spatialite etc no problem so the issue doesn't lie with the data.
What we are thinking to do if to put a condition between the two perhaps a counter/sampler which then after say 100 tables are transferred we put a decelerator so that it then can hopefully get it's composure back before it kicks off again.
Is this possible, has anyone done something similar. I guess it would also be useful if for example you needed to report back progress to a application to report how many feature are complete you could report back a counter of some type.
Thanks for the help as always,
Oliver