Can someone please suggest something to improve the performance?
Best answer by david_r
View originalCan someone please suggest something to improve the performance?
Best answer by david_r
View originalI would try using the InlineQuerier and perhaps also the FeatureJoiner for this. Also make sure that you're using a recent version of FME.
Finally, make sure to switch off both breakpoints and feature caching in FME Workbench, this can have a huge influence on performance when working with such volumes.
It's possible that the best performance will be had by first reading everything into a proper database with lots of RAM, properly indexing all the relevant columns and doing the join in SQL, e.g. using an SQLExecutor or SQLCreator.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.