Skip to main content
Question

Possible bug in Access mdb reader.

  • October 11, 2018
  • 1 reply
  • 7 views
paalped
Contributor
Forum|alt.badge.img+5

I just discover when choosing to read from an Access database with MAX_FEATURES_PER_FEATURE_TYPE set it still reads the whole dataset before selecting my number of inputs:

2018-10-11 12:31:58|   0.5|  0.0|STATS |Storing feature(s) to FME feature store file `C:\Users\paalp\AppData\Local\Temp\visual_inspection_123158\inspector.ffs'
2018-10-11 12:36:40| 284.2|283.8|INFORM|Microsoft Access Reader: Database read complete.  Retrieved 1561980 feature(s)
2018-10-11 12:36:41| 284.3|  0.0|INFORM|Microsoft Access Reader: Closing `C:\Users\paalp\OneDrive - Geodata\Prosjekter\MD-darwin\BarentsVisual\BarentsVisual.mdb' . Read operation complete
2018-10-11 12:36:41| 284.3|  0.0|INFORM|MULTI_READER(MULTI_READER): Done reading 1000 features from 1 readers

This seems very backwards, it first read all 1561980 features, and then it reads 1000 of those. While I'm waiting several minutes for the read to finish. Is this a bug in the reader?

FME 2018.1

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

paalped
Contributor
Forum|alt.badge.img+5
  • paalpedContributor
  • Author
  • Contributor
  • October 11, 2018

The read speed drastical increased if I changed the "Number Of Records To Fetch At A Time" to a greater number.

Community Stats

32,120
Posts
121,954
Replies
39,772
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.