When reading very large amount of spatial data from a Database within the FeatureReader, the process could take a very long time. Is it possible to pause the reading, while reading within some time intervals?
In fact, I have a database locked at night for updating daily changes and I would like to pause the FeatureReader (if currently running) during the night and resume the next morning.
In advance thanks.
It is not possible to pause just the FeatureReader, you can pause the workspace.
If reading a large number of features is the issue try reading batches of features with the help of the readers parameters for example max number of features to read and feature types to read.
Hope this helps.
Is there any way to query subsets? Even if you paused it, I suspect our connection would persist and I don't think you'd get the desired result. Another option might be to have a trivial workspace to just dump the database into FFS, and then do whatever downstream processing that takes longer going from the resulting FFS file.
Thanks for your hints.
I will fetch the needed data in a time-controlled manner through a prior script in order to have all needed data locally.