SQLite Forum

Question about memory management
Login
Unless you are using an in-memory database, doing a CSV import should not present any particular problem for the CLI.

Setting SQLITE_DEFAULT_MEMSTATUS to 0 will hinder getting memory usage data from the SQLite instance, but will not be the culprit in excessive memory use. If you want to see where that problem is, you may want to leave that option at its default (1).

I think you should explain how your Clarion code does the import before hoping for much help here. SQLite is not generally a resource hog.