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 <[email protected]> wrote: > ** > > > On Tue, 30 Jul 2013 09:37:09 +0100, Nick Upson <[email protected]> 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 [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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
