Solved

SQLite VACUUM command after writing to db file

  • 17 October 2019
  • 1 reply
  • 4 views
Y
I was wondering if anyone might be able to help me out? I'm writing tabular data to a SQLite database and I'd like to run the VACUUM command after it's been written. I thought it might exist in the SQLITE3 writer parameters but no luck. I'm using FME 2019 desktop
icon

Best answer by erik_jan 17 October 2019, 22:59

View original

1 reply

erik_jan
Rank
Userlevel 2
Badge +12

The SQLite writer has the option to run a SQL command after the data is written.

See this SQLite writer parameters documentation for more info.

Reply


Community Stats

28,634
Posts
109,179
Replies
36,513
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.