The following workflow of comparing tables (in two separate databases) and updating an existing database (SQL non-spatial) is taking for ever. It has been running for 12 hours now to update the database. In 12 hours only 5424 records are compared. I am expecting about 20,000 records to be updated weekly based on update detector comparison. The change detector transformer is in the workbench since I tried that approach as well but failed. How can I make the workflow run faster?
Is the target table indexed on the key value that you are using in the fme_where?
That could speed up the writing.
Second, could you group the source records some way?
Comparing 1000 with 1000 twenty times is a lot faster than comparing 20000 with 20000 once.
Hope this helps pointing in the right direction.
Is the target table indexed on the key value that you are using in the fme_where?
That could speed up the writing.
Second, could you group the source records some way?
Comparing 1000 with 1000 twenty times is a lot faster than comparing 20000 with 20000 once.
Hope this helps pointing in the right direction.