Subject Re: [firebird-support] Re: Why it's soo slow ? it's jus t a very simple select ...
Author Mark Rotteveel
On Wed, 07 Mar 2012 06:25:54 -0000, "nathanelrick" <nathanelrick@...>
> yes Rick, but what will be my job after :( i will be fired because i
> 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
> just to read the index because index will use very lot of pages ... or
> a bug in firebird ! anyway the answer will not help ! here i just want
> 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
> 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.


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