Skip to main content
  • EN

I would like to write features to a local file to read back in later and looking for the best file type for performance.

My local machine does not have any DBs to use for this purpose (Oracle, SQL, etc)

so I am limited to files I can save to a PC folder.

Does FME have it's own DB file type that I could be utilizing?

  • I tried FME Feature Store (FFS) but it has limited functionality, such as not being able to set truncate or table drop on runs. And it's main purpose is to add encryption which I don't need and seems like it hurts performance.
  • I have read on here that CSV is very high performance but I don't want to lose metadata such as data type, len, etc.
  • Excel has a feature limit that does not work for me.

 

If you need a "real" database, then you could always consider using SQLite. There are no dependencies other than what is already installed with FME.

 

Reply


Community Stats

30,351
Posts
115,341
Replies
38,082
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.