Hi! I am also interested in this subject ...
Have you tried using an Access Reader instead of a pGDB Reader? I think it could speed it up a bit, but the Joiner would have been the first thing I 'd suggest. Didn't know about the date fields ... Perhaps you could set up a "query" in Access that converts your dates to integers or strings an then you could use the joiner to read that "query" Greetings from Switzerland, Jeff On 2/16/07, snelsons2006 <[EMAIL PROTECTED]> wrote:
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
