Hey there,
I have a few workspaces that make use of the Esri File Geodatabases readers and writers. Processing a huge amount of data comes with some issues. In the past i had noticed a huge slowdown of my performance once i hit the last few transformers in the line.
Last week i noticed the log line that comes up during the negative performance switch.
The line states: Optimizing Memory Usage (something something)
Ram usage stabilizes from ~2,7 GB down to about 2,4GB and does not rise anymore. I have more than 10GB of available space left but it will not use more, probably because its the 32bit version.
After that point, i will only be able to process around 5-10 objects a second! This is extremely slow if compared to before that point, which was around the thousands a second or even more.
I am looking for a solution to this issue and came up with the following idea:
If i export the data from the file geodatabase in FME 32bit to something supported by FME 64bit, do the processing on that exported date & after that processing is done, convert it back to esri geodatabase in the 32bit version of FME. This could potentially work around the 32bit resource limits.
What do you think of this idea? And to avoid data loss or unwanted mutations, what file formats would be recommended for the export/exchange files between FME 32 and FME 64 bit (while working with file geodatabases).
I hope this is a solution many can benefit from. Perhaps even be integrated by the FME application itself?
Nick