Hello Firebird-Group,

With our device we recalculate statistics ALWAYS when booting up the
system. Now the DB grows bigger this can now take more than 10 minutes and
delays
the time until we can really work with the system. As it is not a server
and we expect the system to be restart from time to time this is a problem.

Is there a better way to find out when to recalculate statistics?
- After n inserts?
- After n days?

And: Is it really such a big performance benefit to recalc the statistics
at all?

BR

Matthias

P.S. Firebird docs only recommend to do it "regularly":
 http://www.firebirdfaq.org/faq167/

Reply via email to