thanks Mark,

i m just a little sorry to disturb the devel (they must be busy) and want try to see 1rt here...

i will make a simple demo and try to post on the devel ... but if the index have they own space then for sure it's a bug (not really a bug, but a bad optimized function in the engine)

> 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).

aaah ok... thanks to warn me, i was not aware it's can disturbe ... i will avoid them now

--- In firebird-support@yahoogroups.com, Mark Rotteveel <mark@...> wrote:
>
> 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).
>