IIRC sqlite databases aren't automatically compacted when things are deleted from them. You need to use the 'vacuum' command to do that.
On Thu, May 28, 2009 at 2:44 PM, jade <[email protected]> wrote: > > When we delete items from our sqlite database in our Android app, the > size of the data under our application (under the G1's settings -> > Applications -> Manage applications) doesn't change. It changes when > we add data but not when we delete it. > > We have a debugging mode where we query the sqlite database and from > that data I can tell that the records have been deleted. > > Is anyone else having this problem? I've also looked at this post: > > http://groups.google.com/group/android-developers/browse_thread/thread/47dc864c667b6dab/cf8e72c7349c2a88?lnk=gst&q=G1+storage# > > we only have 18 unlinked records so I don't think this is the problem. > > Jade > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -~----------~----~----~----~------~----~------~--~---
