[development] optimize table in cron

Gildas COTOMALE gildas.cotomale at gmail.com
Mon Dec 5 08:45:59 UTC 2005


2005/12/5, Bèr Kessels <ber at webschuur.com>:
> Op maandag 05 december 2005 07:42, schreef Dries Buytaert:
> > On 05 Dec 2005, at 04:29, David K Norman wrote:
> > > Has it ever been discussed to run a query to optimize some of the more
> > > active tables in MySQL during cron.php runs? For example 'OPTIMIZE
> > > TABLE
> > > watchdog;'
> >
> > OPTIMIZE TABLE is a MySQL-ism; it's not ANSI SQL.
>
+1 David : all good dev trying to make a portable app must try to be
closer to the standart and open to a wide env. if possible...

> MySQL.inc is not included in the module hooks AFAIK. so adding a hook_cron to
> mysql.inc is not an option.
>
> This could be added in a conditional structure to dba.module
>
+2 Bèr : this doesn't go against the previous point and help much...

> Ber
>


--
vi is a real WYSIWYG editor: you see text, you get text.


More information about the development mailing list