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.