From: Vlad H. <hv...@us...> - 2007-01-05 14:17:08
|
> > Who are 'scared' ? We already discussed with Dmitry needs of auto-update > > statistics (years ago) and have the same conclusion as i wrote in prior letter. > > In FB2 we don't need it much, period. There are only way to be in trouble after > > migrating to FB2 - not perform recommended backup\restore circle but create > > new database from script and pump it with data from old database. If people so > > smart to do such non-obvious step than they must be smart enough to update > > statistics. This is mine POV > > > I am database app developer, so when I develop complex database app and > I deliver this app with empty database to my customer and customer start > working with app ... inserts data ... database grows ... after year > database is 1GB big. (no backup/restore is done ... only backup :-)) > So I must care about updating index statistics at application level ? Yes of course. And this is true for every FB\IB version > (because db engine does not it perform automaticaly) Wow, really ? Why engine does not perform backup automatically ? Why users must enter data into it by hand ? What a stupid engine :))) Regards, Vlad PS I don't said that we never implement auto-update statistics. We will do it. But when we will really need it. Not now ;) |