[GRASS-dev] [GRASS GIS] #3697: sqlite db: automatically enable vacuum

GRASS GIS trac at osgeo.org
Tue Nov 20 11:27:37 PST 2018


#3697: sqlite db: automatically enable vacuum
--------------------------+---------------------------
  Reporter:  mlennert     |      Owner:  grass-dev@…
      Type:  enhancement  |     Status:  new
  Priority:  normal       |  Milestone:  7.8.0
 Component:  Database     |    Version:  unspecified
Resolution:               |   Keywords:  sqlite vacuum
       CPU:  Unspecified  |   Platform:  Unspecified
--------------------------+---------------------------

Comment (by neteler):

 VACCUMing is a great improvement!

 Replying to [comment:1 mmetz]:
 > I would prefer to VACUUM the sqlite db when the GRASS session is
 terminating, i.e. in lib/init/grass.py. This would not slow down standard
 db operations and leaves the db in a clean state.

 I would like that idea as well to add that during session termination.

 Perhaps likewise also for PostgreSQL and mySQL/MariaDB?

-- 
Ticket URL: <https://trac.osgeo.org/grass/ticket/3697#comment:2>
GRASS GIS <https://grass.osgeo.org>



More information about the grass-dev mailing list