Question

Performance issues with Microsoft Access JDBC writer

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

2 replies

M
Badge +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

@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.

Reply


Community Stats

28,731
Posts
109,528
Replies
36,565
Members
Terms & ConditionsCookie settings
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.