On Fri, May 20, 2011 at 5:34 AM, Maya Opperman <maya@...> wrote:

> Hi,
>
> I've managed to identify which table is the largest in a database (by using gstat, and looking at the result summary in IBExpert) but now I need to know if there are one or two records causing more problems than others.
>
> ie. I have a stock table containing images in 3000 records, and I need to be able to see if just a few of those records are much bigger than the others, so that those can be amended.
>
> Any ideas how I can do that?
>

The API includes a Blob Info call that will give you the length of a
blob if you
give it the blob id. It's not easy to use, and I don't know if the
capability is
surfaced in any other tool.


Good luck,

Ann