Thanks Sean

Yes this is already an FB 2.0 DB. Is the issue caused by having
duplicates? If so We might have to look at removing some indexes. i.e.
RegionRef in some users data will only contain one value, whereas in
others there might be 2 or more values.

Essentially this forms a CPK, ItemRef + RegionRef uniquely identify a
record.

Thanks Rob

Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd



Leyne, Sean wrote:

> Robert,
>
>
>> I thought I would check our DB after reading this thread. We have a
>> number of index depths of 3 (none above) our DB is using a page size
>>
> of
>
>> 8192. I show the details of a couple of the more commonly used tables
>> that have a high index depth. Are these bad, what sort of issues
>> (performance wise) will this cause. Is the best way to deal with it
>>
> to
>
>> increase the page size further?
>>
>
> In most cases; yes.
>
> If you are using v1.x, upgrade to 2.0. The engine does a much better
> job of handling indexes with large numbers of dups
> (STOCKMOVEMENT_REGIONREF -- 65% of the records have a single value, with
> 574000 dups!!!)
>
>
> Sean
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>