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,
View original
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 a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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 a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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.
+17- Contributor
- 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
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.