Solved
Performance enhancement in sql calls
I am using few sql executors for calling procedure/function, select on multijoin, selecting from dual. For 30 features it takes around 15 seconds. But when it comes to 10000 features , processing takes a lot of time. Is there any way to improve performance? Thanks, Subrat
Best answer by fmelizard
Hi,
I this case its the database that can use the tunning and not FME, since you are using the databse to do the work.
You could check if the features used are properly indexed for starters.
Itay
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.
+21- Safer
- Best Answer
Hi,
I this case its the database that can use the tunning and not FME, since you are using the databse to do the work.
You could check if the features used are properly indexed for starters.
Itay