Subject RE: [ib-support] Child Tables Problem Revisited
Author Bill Morrison
Thanks for the input Ann.

Unfortunately, there is no slow period with this product, it's always going
full blast.

However, it appears that in my deletion sproc doing something like :

delete * from sometable where pk=:thepk;
select count(*) from sometable where pk=:thepk into :tempvariable;

This appears to reclaim the space, and doesn't have a huge impact on
performance, although testing isn't complete.

If this is the final solution, thanks to everyone on the list for assisting
me with this rather annoying problem.


-----Original Message-----
From: Ann W. Harrison [mailto:aharrison@...]
Sent: Friday, November 02, 2001 10:01 AM
To:; ''
Subject: RE: [ib-support] Child Tables Problem Revisited

At 08:58 AM 11/2/2001 -0800, Bill Morrison wrote:

>Now, the tables I'm dealing with hold more than a million records, and the
>application is doing real time (more or less) data capture. Is there a
>different way to "touch" the deleted records so they go away?

If you run gbak during a slow period with garbage collection turned on
you should get your space back.


We have answers.

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to