Article View: borland.public.interbase.opensource
Article #150Re: IB 6020 Sweeping not preventing database growth
From: Bill Todd
Date: Tue, 06 Sep 2005 02:55
Date: Tue, 06 Sep 2005 02:55
9 lines
1234 bytes
1234 bytes
Did you commit the delete transaction before you ran the sweep? Sweeping will not reduce the size of the database. It just removes row versions so the space they occupied can be reused. The database will still grow when you process the firs file but should grow less for subsequent files. -- Bill Todd (TeamB)
Technical Details
Message-ID:
<431d0538$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<431cf7a8.171457212@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 106772,522a4d66cc980aa7
X-Google-Attributes: gid106772,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bill Todd" <no@no.com>
Subject: Re: IB 6020 Sweeping not preventing database growth
Newsgroups: borland.public.interbase.opensource
References: <431cf7a8.171457212@newsgroups.borland.com>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.17.5.9
X-Face: ":yn4zt^A_dn>6~{YJmu^B\'4w)e:apPM\VC=Dvf&*tASxX9|BYczkFd$xr.$vNSZ[3Uobr p]c4\+\l){!WQI.$]veP({HLd;CDYH?iN
NNTP-Posting-Host: 216.207.211.19
Message-ID: <431d0538$1@newsgroups.borland.com>
Date: 5 Sep 2005 19:55:52 -0700
X-Trace: newsgroups.borland.com 1125975352 216.207.211.19 (5 Sep 2005 19:55:52 -0700)
Lines: 9
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail