--- In informaticadevelopment%40yahoogroups.com">informaticadevelopment
yahoogroups.com, Anjum Parvez
<mapsiddiqui...> wrote:
>
> Nico,
>
> I think even in cases of performance issues with complex
> queries you can resort to manipulations at database level
> to improve the execution time. In one particular case we
> used staging tables to workaround the excessive run time
>; of one query.
<snip>
That was the exact reason why I've written "Try it in every single
case". There are too many factors which influence the overall
performance of mappings. My strategy (which I adopted only within the
last 12 months) is: first I try to do as much within a mapping as
possible; if I encounter performance issues that are really easily
remedied by transfer of tasks to the source DB, then I try this. But
as mentioned: you have to try. Every time.
Regards,
Nico
.
