New topic: Compress RS database after deleting pictures
<http://forums.realsoftware.com/viewtopic.php?t=44800> Page 1 of 1 [ 2 posts ] Previous topic | Next topic Author Message grechcj Post subject: Compress RS database after deleting picturesPosted: Sun Jul 22, 2012 12:24 am Joined: Sun Feb 14, 2010 11:19 pm Posts: 173 Location: Australia Thanks to those who replied to my previous querie re: adding pictures http://forums.realsoftware.com/viewtopic.php?f=1&t=44741. All is working fine now but I have another problem with pictures, hence a new thread. When I add a picture it adds up to 11kb to the database file size depending on the size and quality chosen. Trouble is when you delete the picture the database doesn't reduce in size. I know in other databases such as Access there is a compress option which cleans up empty allocations. Does SQLite have this? My only working option at present is to give the user a compress command which runs a function to create an identical database and copy everything across, ommitting empty fields before deleting the original. A risky piece of code I'm not proud of but it does reduce the file size again. Top shaosean Post subject: Re: Compress RS database after deleting picturesPosted: Sun Jul 22, 2012 12:51 am Joined: Mon Aug 15, 2011 10:25 pm Posts: 141 http://www.sqlite.org/lang_vacuum.html/ Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 2 posts ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
