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?
Question
Workspace hangs while reading from MS SQL Server
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
Lower the number of features to read?
+13- Safer
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.
+18- Supporter
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