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
> <[email protected]> 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
_______________________________________________
LibreOffice mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice
