Hi Richard,
I don't see your log file so can't really comment.
However, on a related topic, I'd suggest you check out the Joiner page
on fmepedia - http://www.fmepedia.com/index.php/Joiner
There's a whole load of settings in the Joiner that you can use to
help performance, namely reading the likely hits into a cache and
setting that cache size. You'll see in the log a line like...
@Relate: Database query statistics for table `JOINER:MY_TABLE':
7 queries made of which 0 were sequential duplicates
and 1 hit the record cache of 3 records (14% overall cache hit)
...which indicates how efficiently the process is working. The higher
the cache hit the more efficient the process, because FME is storing
the data in a cache and not having to repeatedly query the database.
Just thought I'd mention it, in case you had used the default settings
in the Joiner without being aware what benefits they might bring.
Regards,
Mark
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/fme/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/fme/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
