Skip to main content
Solved

Sluggish performance with comment field

  • July 10, 2024
  • 1 reply
  • 46 views
colejo02
Contributor
Forum|alt.badge.img+5

Hello, I am a first-time poster on the FME forum. My goal is to read data stored in a plain view from a non-spatial Oracle database and then write it to an Oracle SDE geo_dbtable. 

The issue is that my Oracle Non-Spatial Reader slows down, taking more than 30 minutes to execute the SQL Statement when I include two comment fields that are long, 2000 characters. When I run the same query in SQL Developer, the result is back in a few seconds.   

The log message that gets stuck on is:  ORACLE Reader: Executing SQL Statement `SELECT…<field names> to obtain features for feature type <Oracle View Name>

If I uncheck the comment fields in the User Attributes tab the reader returns quickly, within a minute.  So I’m skeptical that it is caused by network distance.  

Given these challenges, I need some guidance. I’ve tried using an Oracle NCLOB to hold the comments in the view, but the result remains sluggish. I'm eager to learn how to optimize my workbench's performance when dealing with large comment fields.   

I am using Data Interoperability FME(R) 2023.1.1.1 (20231011 - Build 23636 - WIN64)

Thanks, Josh

Best answer by colejo02

Hello I figured out how to improve performance in my model.  I had several unneeded transformers, readers, and writers in the workflow. I disabled/deleted these and their connections and the model performance improved. The post below also provides suggestions on how to speed up Oracle readers.  

 

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

colejo02
Contributor
Forum|alt.badge.img+5
  • colejo02Contributor
  • Author
  • Contributor
  • Best Answer
  • July 11, 2024

Hello I figured out how to improve performance in my model.  I had several unneeded transformers, readers, and writers in the workflow. I disabled/deleted these and their connections and the model performance improved. The post below also provides suggestions on how to speed up Oracle readers.  

 

Community Stats

32,128
Posts
121,966
Replies
39,779
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.