Re: Bulk inserts makes GDB grow

Article View: borland.public.interbase.sql

Article #11185

Back to borland.public.interbase.sql Previous Next

#11185

From: Bill Todd
Date: Mon, 09 Dec 2002 18:33

18 lines
1358 bytes

delete * from stock
Commit
StartTransaction
select * from stock
insert into stock (id...) values (:id ...)

Doing the SELECT will let IB garbage collect the deleted rows.

On Mon, 4 Nov 2002 18:43:42 +0100, "Dietrich v. Witzleben"
<info@witzleben-edv.de> wrote:

>delete * from stock
>insert into stock (id...) values (:id ...)


--
Bill (TeamB)
(TeamB cannot respond to questions received via email)

Technical Details

Message-ID: <pco9vu8ggnpbrg8jq30okset41k765j7nb@4ax.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!uunet!dca.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <3df4d656$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,6aab62eb63eb5ff1,start
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-09 10:36:06 PST
From: Bill Todd <bill@notthis.dbginc.com>
Newsgroups: borland.public.interbase.sql
Subject: Re: Bulk inserts  makes GDB grow
Date: Mon, 09 Dec 2002 11:33:04 -0700
Message-ID: <pco9vu8ggnpbrg8jq30okset41k765j7nb@4ax.com>
References: <3df4d656$1@newsgroups.borland.com>
X-Newsreader: Forte Agent 1.91/32.564
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 216.207.211.30
X-Trace: newsgroups.borland.com 1039458785 216.207.211.30 (9 Dec 2002 10:33:05 -0800)
Lines: 18
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!uunet!dca.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message