>
>At 07:29 AM 11/22/2004, Alexander Marx wrote:
>
>
>
> >hm, can i somehow disable that garbage-collection stuff on selects?
> >setting sweep intervall to "0" does not seem to make a difference
> >again results in a 50000 seconds "wait" on the first select ...

At 10:27 AM 11/22/2004, Ann W. Harrison wrote:

>Setting the sweep interval has no effect on garbage collection by
>the garbage collect thread or active transactions. You can disable
>garbage collection on a transaction by transaction basis - check
>the tpb options - but that's an unfriendly thing to do and will
>tend to make your database much slower over time. My guess is
>that your problem is with a non-selective index and correcting
>that will improve everything

In fact, it's an attach parameter - but still unfriendly.


Ann