[PATCH] [REVIEW:3-5,3-6] size optimisation

[Lionel Elie Mamane]

On Wed, Jul 04, 2012 at 09:30:20AM +0200, Miklos Vajna wrote:
> On Tue, Jul 03, 2012 at 08:33:13PM +0200, Lionel Elie Mamane <lionel at mamane.lu> wrote:

>> The alternative would be to introduce an UI element
>> "compress/cleanup/defrag database", but:

>> 1) It would necessarily be specific to sdbc(x) direct drivers as AFAIK
>>    odbc / jdbc / ... don't have a standard way to do such an
>>    operation.

> Hm, but what you're doing right now is just executing a statement,
> that's possible with any odbc/jdbc as well, right?

Yes, but *which* statement that is depends on the underlying database
engine. For example:

 * HSQLDB: "CHECKOPOINT DEFRAG;" will do it on the whole database

 * MySQL:  "OPTIMIZE TABLE foo, bar, qux;" will do it on tables foo,
            bar and qux. To do on the whole database, need to list all
	    tables.

 * PostgreSQL: "VACUUM FULL ANALYZE;" will do it on the whole database

-- 
Lionel