Hi, For me your stats look strange in one place but i am not expert on FB internals.
For me strange is avg rec len 125 before 133 after - you have not rec ver to make this .difference Question is - is table same as before? Did you change characterset? ... May be someone else can help.. Regards, Karol Bieniaszewski ----- Reply message ----- Od: "Nick Upson" <n...@telensa.com> Do: "firebird support" <firebird-support@yahoogroups.com> Temat: [firebird-support] big change after restore Data: wt., lip 30, 2013 11:41 gstat -r output: pre backup/restore Primary pointer page: 636, Index root page: 637 Average record length: 125.93, total records: 129599 Average version length: 0.00, total versions: 0, max versions: 0 Data pages: 1441, data page slots: 1849, average fill: 98% Fill distribution: 0 - 19% = 1 20 - 39% = 4 40 - 59% = 0 60 - 79% = 2 80 - 99% = 1434 post backup/restore Primary pointer page: 635, Index root page: 636 Average record length: 133.93, total records: 129599 Average version length: 0.00, total versions: 0, max versions: 0 Data pages: 1211, data page slots: 1211, average fill: 99% Fill distribution: 0 - 19% = 0 20 - 39% = 0 40 - 59% = 0 60 - 79% = 1 80 - 99% = 1210 I obviously expect some improvement from backup/restore but 15x seems more than can be accounted for On 30 July 2013 10:15, Nick Upson <n...@telensa.com> wrote: > Hi Mark, > > I believe I've eliminated fragmentation as the gstat output for the tables > is almost identical, no other connections to the database exist, so its not > an OIT issue > > > On 30 July 2013 10:07, Mark Rotteveel <m...@lawinegevaar.nl> wrote: > >> ** >> >> >> On Tue, 30 Jul 2013 09:37:09 +0100, Nick Upson <n...@telensa.com> wrote: >> > Hi Thomas, >> > >> > I am running classic firebird 2.1, but I don't think its GC as I ran >> both a >> > sweep and a backup and still got the same, longer, time >> >> It can be a different number of issues: less fragmentation, no (or >> shorter) record version chains, large difference between OIT and the >> current transaction number in the database before backup causing >> continuous >> sweeps or something like that. >> >> Mark >> >> >> > > > > -- > Nick Upson, Telensa Ltd > -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed] ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links [Non-text portions of this message have been removed]