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. ------------------------------------------------------------------------- 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