Subject | Re: [firebird-support] Large DB after batch import: index rebuild/set stats, backup/restore? |
---|---|
Author | Kjell Rilbe |
Post date | 2010-11-09T22:10:44Z |
Ann W. Harrison skriver:
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
> > Also, what considerations should I make regarding page size? Maybe IWell, I'm running a gstat on the largest table (regarding record count).
> > should bump up the page size?
>
> How deep are your indexes?
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