Subject | Re: [firebird-support] Re: Why it's soo slow ? it's jus t a very simple select ... |
---|---|
Author | Mark Rotteveel |
Post date | 2012-03-07T07:57:23Z |
On Wed, 07 Mar 2012 06:25:54 -0000, "nathanelrick" <nathanelrick@...>
wrote:
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).
wrote:
> yes Rick, but what will be my job after :( i will be fired because iwill
> become useless :(record,
>
> 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 ... orit's
> a bug in firebird ! anyway the answer will not help ! here i just wantto
> point that this behavior is not acceptable for a good database engine !private
>
> 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.
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).