Can someone suggest the most efficient (fastest) way to query records 
from a PGDB to then feed the results to the FeatureMerger?

Background if interested:  I need to read a large PGDB table (>400k 
records), and 'join' to other data in and FME.  If I add it in as it's 
own Datasource it takes a while to read all the records and I don't 
see how to do a pre-fetch, I can't use the JOINER because it drops the 
time values with any date fields.  I've tried using the SQLExecutor 
with no input,just calling the table I need, but I can't get any data 
to come out of it.

Thanks for any suggestions
Steve



For insights into what's up at Safe Software and what's on the development 
horizon, visit Safe's blog at spatial-etl.blogspot.com.

Safe Software has also made slides available that outline enhancements planned 
for FME 2007. The slides are from the "Road Ahead" presentation given on Day 2 
of the FME Worldwide Users Conference. To view these slides, visit 
www.safe.com/2006uc.

 
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/
 

Reply via email to