search

alexkyllo / bots

Automatically exported from code.google.com/p/bots
2 stars 0 forks source link

add: run vacuum in cleanup #174

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
as (most of) cleanup now runs once a day: 
add vacuum (for sqlite).
vacuum might take some time, but this is not a problem if this runs only one 
time a day.

Original issue reported on code.google.com by hjebb...@gmail.com on 20 Sep 2012 at 1:58

GoogleCodeExporter commented 9 years ago 
For my database, size approx 450Mb, 1.5 million ta records, 14 days history. 
Vacuum takes about 10 minutes each night after cleanup. Database size reduces 
20 - 30 Mb.

Original comment by mjg1964 on 24 Sep 2012 at 12:49

GoogleCodeExporter commented 9 years ago

Original comment by hjebb...@gmail.com on 10 Sep 2013 at 12:45