mORMot Open Source

itSDS

Member

From: Germany

Registered: 2014-04-24

Posts: 516

SynLog without BLOB - Parameter Values

Hi, i store ~ 100GB in SQLite DB and have SYNLOG with LOG_VERBOSE active.
My LOGS are growing rapidly because the BLOB Data is stored in the Log as Parameter to mOTMotSQLite3.TSQLRestServer INSERT/UPDATE Log Entries.

Is there a Option to disable the Loging of BLOB Contents. I would like to have the other SQL - Log Entry only the BLOB Parameter should not be saved (for example Replaced by BLOB(Size:616000)) Size is optional ..

BR
Stefan

Last edited by itSDS (2019-03-12 11:46:32)

---

Rad Studio 12.1 Santorini

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,671

Website

Re: SynLog without BLOB - Parameter Values

You can reduce the log verbosity as such:

  result := TSQLRestServerDB.Create(model, filename, false,  '', aCacheSize, 4096);
...
  result.StatementTruncateSQLLogLen := 2048; // up to 2KB of raw SQL in logs
  result.DB.LogResultMaximumSize := 2048; // up to 2KB of JSON result in logs

itSDS

Member

From: Germany

Registered: 2014-04-24

Posts: 516

Re: SynLog without BLOB - Parameter Values

ty it works

---

Rad Studio 12.1 Santorini