On Wed, 07 Mar 2012 06:25:54 -0000, "nathanelrick" <nathanelrick@...>
wrote:

> yes Rick, but what will be my job after :( i will be fired because i

will

> become useless :(
>
> but what the specialist will say me here ? yes it's a true disaster, the
> index entries are spawn in the record page, mean that if your row is 32k
> (for exemple) then it's will be dammed sloww, not to retrieve the

record,

> just to read the index because index will use very lot of pages ... or

it's

> a bug in firebird ! anyway the answer will not help ! here i just want

to

> point that this behavior is not acceptable for a good database engine !
>
> and how do you want to pay a specialist just to answer this simple
> question ?? it's not possible, we will need a DBA at full time ...
>
> but ok, if someone have some assistance offer, i will study it (in

private

> please, nathanelrick@...)

Indexes have their own page type, so they are not on the same pages as
your data. I don't know your exact usage, nor the exact inner workings of
your index. Maybe you could post your problem to firebird-devel as well, to
see if the developers have an insight.

Mark

PS I think you make excessive use of ':(' and exclamation marks in weird
places; it makes your mails hard to read (at least for me).