Subject | Re: [ib-support] Index problem |
---|---|
Author | Nando Dessena |
Post date | 2001-08-09T14:46:33Z |
Guido,
index pages in the cache, thus eliminating your data pages which were
there at the beginning (when you inserted the data).
If this were true, you would experience a much smaller delay when trying
to open the query a third time.
HTH
--
____
_/\/ando
> I have a empty DB and I insert several thousands of datasets. Now I open<SNIP>
> a query and it takes 0,1362 sec. Now I deactivate all my indices
> Then I acivate all my indices<SNIP>
> Now I open the query again and it takes nearly 4 sec.my guess is that the rebuild operation has forced IB to get all the
>
> Have anybody a idea, what the reason is for this behaviour ?
index pages in the cache, thus eliminating your data pages which were
there at the beginning (when you inserted the data).
If this were true, you would experience a much smaller delay when trying
to open the query a third time.
HTH
--
____
_/\/ando