New topic: VACUUM not working
<http://forums.realsoftware.com/viewtopic.php?t=44028> Page 1 of 1 [ 3 posts ] Previous topic | Next topic Author Message jas1931 Post subject: VACUUM not workingPosted: Wed May 16, 2012 7:04 am Joined: Tue May 31, 2011 9:16 am Posts: 75 Location: Chapin, SC Here is my code to perform VACUUM on a database and if does nothing If gDB.Connect Then gDB.SQLExecute ("VACUUM") if gDB.Error then MsgBox "Could not VACUUM " + gDB.ErrorMessage+ EndOfLine + CurrentMethodName else gDB.Commit end if What am I doing wrong? _________________ Jim Smith http://www.rvcarelogbook.com Mac OSX 10.7, RS 2011R4.3 Top DaveS Post subject: Re: VACUUM not workingPosted: Wed May 16, 2012 8:54 am Joined: Sun Aug 05, 2007 10:46 am Posts: 3693 Location: San Diego, CA a) what database format? (SQLite? mySQL etc) b) "does nothing" or "generates an error" If it does NOT generate an error, how do you know it did nothing? VACUUM doesn't offer a lot in the way of feedback.... and unless your database was terribly fragmented... you might not see a filesize difference (especially if your OS reports filesize in BLOCKS ) _________________ Dave Sisemore MacPro, OSX 10.7.3 RB2011r3 Note : I am not interested in any solutions that involve custom Plug-ins of any kind Top Jym Post subject: Re: VACUUM not workingPosted: Wed May 16, 2012 7:14 pm Joined: Sat Oct 01, 2005 5:19 pm Posts: 3042 Are you connected to the database? Maybe gDB.Connect = False? Are you already connected and in the middle of a transaction? How much have you deleted? Are you 'allowed' to vacuum? Other than those things, I can't see any issue Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 3 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]
