But should it? We have links to the company database (db2 series 1), as well as a back end access database on the network. We have a query for fields on the company database that looks like a spider web on the query design screen, and if we restrict those all to one record, it runs in under a second. (About 20000 records queried)
When we run a query on a single linked table restriced to one record on an indexed field value, it takes about 8 seconds. We are already keeping the linked table 'open' as reccomended at this site:
(site removed due to low post count)
But didn't notice a performance boost.
Is there something we're missing? Should it take that long?
When we run a query on a single linked table restriced to one record on an indexed field value, it takes about 8 seconds. We are already keeping the linked table 'open' as reccomended at this site:
(site removed due to low post count)
But didn't notice a performance boost.
Is there something we're missing? Should it take that long?
