Subject Re: [firebird-support] Large DB after batch import: index rebuild/set stats, backup/restore?
Author Kjell Rilbe
Ann W. Harrison skriver:
> > Also, what considerations should I make regarding page size? Maybe I
> > should bump up the page size?
>
> How deep are your indexes?

Well, I'm running a gstat on the largest table (regarding record count).
I'll post an answer tomorrow.

The next largest table has an å in the identifier so I've failed to
produce a gstat command line that works. I'd appreciate any helpful
suggestions regarding that issue. (Windows command prompt, DB default
charset = UTF8).

Running gstat on the entire DB seems less than optimal at this point.

Regards,
Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64