Jason Tackaberry <[EMAIL PROTECTED]> writes: > On Sun, 2006-10-29 at 18:51 -0400, Rob Shortt wrote: >> > * Old program info doesn't seem to be thrown away. On freevo-epg >> > search I get lots of old data, epg.sqlite grew to 45MB (after >> > deletion and new insertion of program info it is only 4.5 MB) >> >> I think sqlite keeps the space allocated unless you specify a flag on >> startup. > > This is typical of DBs. kaa.db has a vacuum() method that should be > called periodically, and will take care of this problem. >
I don't think this is the only reason. The old entries don't get deleted. A small query shows me, that the backup (well, I'm a coward) of epg.sqlite has a lot more entries than the current epg.sqlite: ,---- | [EMAIL PROTECTED] /home/hjficker | hush% sqlite3 /var/lib/freevo/epg.sqlite.old \ | "select title,start,stop,parent_id from objects_program;" \ | | wc -l | 69485 | [EMAIL PROTECTED] /home/hjficker | hush% sqlite3 /var/lib/freevo/epg.sqlite \ | "select title,start,stop,parent_id from objects_program;" \ | | wc -l | 7551 | [EMAIL PROTECTED] /home/hjficker | hush% `---- In fact, the oldest entry in the database was from August, and I had it in use since last Saturday: ,---- | [EMAIL PROTECTED] /home/hjficker | hush% sqlite3 /var/lib/freevo/epg.sqlite.old \ | "select title,start,stop,parent_id from objects_program | where stop < $(date -d 08/16 +%s);" \ | | wc -l | 870 | [EMAIL PROTECTED] /home/hjficker | hush% `---- Best regards, Hans-Jürgen -- "To know recursion, you must first know recursion" ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Freevo-devel mailing list Freevo-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/freevo-devel