In my workspace I am reading from a table in SQL Server. There is a huge amount of records, so I limit the number of records to read (per feature type) to 100k for testing purposes. When the number of features read gets to about 99000, the workspace does not proceed for about 15 minutes. Is there anything I can change here?
Page 1 / 1
Lower the number of features to read?
Are there any clues in the FME log?
Lower the number of features to read?
Are there any clues in the FME log?
Are you just reading features and nothing else in the workspace? Or is there something else (another transformer) causing the delay? If so disable anything after the reader to isolate that it is indeed just the reader.
A good place to give your debugging effort a start and structure is the following article:
https://knowledge.safe.com/articles/19301/root-cause-analysis-guide.html