I got it yesturday but judging by the fix list we will have to do some
careful testing - particularly becuase of the 2 fixes to the optomiser. I
had been forced to use PLAN's on some queries and in stored procs which now
may cause things to slow or break.
We never had crashes during sweeps and the bug you refer to failed when
indexes contain null values - which we don't have as all indexed columns are
not-null - as they should be (?).
Some of the other things in the fix list have shocked me. I was stunned
that cast() could return the wrong results. How do these sort of bugs get
through QA?
>From: Nic Wise <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list database <[EMAIL PROTECTED]>
>Subject: Re: [DUG-DB]: Interbase Performance
>Date: Mon, 01 Nov 1999 16:35:19 +1300
>
>
>
>Peter G Jones wrote:
> >
> > For general improvements (speed or otherwise) I have found the following
> > useful for IB:
> >
> > 1: DONT EVER USE IB 5.1, it's crap. 5.5 is solid.
>
>5.5 has a BIG BUG in it that causes the server to crash when you do a
>sweep. Get 5.6, 'free'* off interbase.com I beleive (or talk to Claire
>for official media - 09-3600231), which fixes this and other problems.
>
>*needs licences for 5.0, 5.1 or 5.5 to work.
>
>Nic.
>--
>Nic Wise - Inprise New Zealand / Brocker Technologies Web Monkey.
>mob:+64.21.676.418 - wk:+64.9.481.9999 x9753 - wk-em:[EMAIL PROTECTED]
>hm: +64.9.277.5309 - hm-em:[EMAIL PROTECTED]
>---------------------------------------------------------------------------
> New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz