Re: [Firebird-devel] AutoOptimize

[= m. Th = <th...@va...>]

LacaK wrote:
>> 1. Add in firebird.conf ChangesToOptimize (=0 disabled) and
>> TimeToOptimize (see UnflushedWrites engine). (Which is the number of Changes to reach and the amount of time from the 
>> last change to pass in order to start the automatic optimization)
>>     
>
> I would preffer "auto-tuning engine" without need setting somethings in 
> config file.
> Similar like MS SQL see  http://support.microsoft.com/kb/195565
>
> -Laco.
Nice article! Thanks a lot! IMHO, Arno will find it very interesting. 
Also see

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/statquery.asp

http://www.microsoft.com/technet/prodtechnol/sql/2005/qrystats.mspx


but also in MS's article is stated something like:

at the very beginning: "The newly-introduced statistical maintenance 
functionality, AutoStat, may generate *unwanted overhead* on a 
production system..."
and at the end you have the 'settings':
    "Controlling whether UPDATE STATISTICS are run against a table"
    "Controlling the number of concurrent UPDATE STATISTICS processes"
and
    "Determining when Autostats are being run"

so they also have configuration settings.

The same (but implemented in a simpler way) was also my idea. To have 
some defaults in the .config which will work for the most of the cases 
(what means here 'most of the cases' is another (big) problem, but let's 
jump...) and if someone wants to tune it, is free to do it. Also, now 
I'm thinking that, besides to the fact that IMHO, it should exists a 
server global configuration set of parameters for this, because is a 
single hardware box, perhaps is nice to have some configuration values 
in each db, which will take precedence if they are not null.


hth,

m. th.