mORMot Open Source

array81

Member

From: Italy

Registered: 2010-07-23

Posts: 411

Compact the database

Hi,

I have found this article about database compact and onther ways to reduce the database size: http://web.utk.edu/~jplyon/sqlite/SQLit … ml#compact (see all capitol 9).

Are these ways availability on Framework?

Leander007

Member

From: Slovenia

Registered: 2011-04-29

Posts: 113

Re: Compact the database

I think you could do it simply via direct call of EngineExecute('VACUUM') of TSQLRest instance.

But you should read first about VACUUM command, that you call it at proper time, synchronized on server side.

---

"Uncertainty in science: There no doubt exist natural laws, but once this fine reason of ours was corrupted, it corrupted everything.", Blaise Pascal

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,660

Website

Re: Compact the database

Yes, VACUUM is the way to do this optimization.

Other ways (like dump to a .db text file) are much slower.