Skip to main content
Question

Performance issues with Microsoft Access JDBC writer

  • May 15, 2020
  • 2 replies
  • 49 views
geojanmov

Hi FME-community,

I'm having problems with the performance of a workspace that straightforward translates a CSV to a Microsoft Acces DB. Somehow the performance is not stable. During the evening it was 30 times slower than during the day, while more memory was available and all other settings did not change. FME Server is deployed on a Azure VM (Windows Server 2016).

 

In the usage notes I read:

The performance of this format is dependent on the amount of memory allocated to the Java Virtual Machine (JVM).

Is this an explanation and how can I solve this?

I hope someone has an answer to this.

-GeoJanMov

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.

2 replies

M
Forum|alt.badge.img+2

@geojanmov Check the section Post-Mortem Performance Tuning in the article Performance Tuning FME

The session duration vs CPU time will give a clue on whether it's FME or a network latency that is consuming the additional time.

geojanmov
  • geojanmov
  • Author
  • May 27, 2020

@markatsafe, the VM uses IOPS in stead of memory, probably due to the limited FME_JVM_MAX_HEAP_SIZE. For now, I use the Microsoft Access writer, which works fine.

Community Stats

32,182
Posts
122,179
Replies
39,856
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.