Subject | Re: [firebird-support] BLOB |
---|---|
Author | Tim Ward |
Post date | 2014-10-13T08:32:46Z |
On 10/10/2014 22:22, Ann Harrison
aharrison@... [firebird-support] wrote:
But, surely, the garbage has to be cleaned out sooner or later, and doing it in a backup run is the cheapest way to do it, as every record is being visited anyway? (Compared to, say, doing a COUNT(*) to clean garbage, which will visit records it doesn't need to, or, worst of all, letting the cost land at random on whichever poor sod next does a query on the table with the garbage.)
Text, binary, it's all the same to gbak. Try the -g suggestion - if gbak is cleaning out garbage, it's slow.
-- Tim Ward