Question

Make Mongo connection faster

  • 11 February 2020
  • 1 reply
  • 3 views

When using the Mongo3 reader, I have real slow connection via FME Desktop, while these connections in Python or other Mongo clients are really quick. Some examples cases where it is extremely slow:

  • creating a Mongo connection + viewing all the available collections
  • picking a collection + displaying it on the Workbench
  • running the FMW file from Workbench, even with filter

All these step can take up to 6min each, for a simple connection. Is there any way to make it faster, like ignoring all the attributes and just use raw JSON (and nothing else)? Listing all the collections from a Mongo server takes a few milliseconds in Python...

I use FME Desktop 2019.2.1.0 (20191202 - Build 19813 - WIN64)

Mongo version is 4.0.13


1 reply

Badge +4

Hello,

I've found that changing the Features Per Request param from the default 2000 to something like 50 has dramatically improved the query speed.

Reply