Oninit cdi / Archive
Talk to an expert →

Re: Slow-running query with temp table on IDS 9.20

Posted in 2000

Topics: Performance & Tuning, Connectivity: ESQL/C, 4GL & Embedded SQL, Versions, Editions & End-of-Life

Obnoxio The Clown — — source: Informix-list mailing list archive (1991-1998)

From: "Neil Truby" <ntruby@netcomuk.co.uk> > >smooth1 <smooth1@iclway.co.uk> wrote in message >news:39bed022_2@news1.vip.uk.com... > > > > > > Oh! 16 second down to 6 with IDS 2000!! > > > > Surely you can prepare and execute an update stats in the > > VB application?? We do so in 4gl applications! > >Well, maybe we can. But really, the question is "Why do we have to?". >This >is just one of a number of differences in behaviour that we're finding in >IDS 9.20. We're not using any of the extended functionality of IDS9.20, so >really want it to behave as v7.x did (only faster!). But we keep getting >bitten in the arse by query plans like this. Well, effectively you've regressed from the 7.31 optimiser to the 7.30 optimiser. So there could be all sorts of differences. _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.

↪ replying to Obnoxio The Clown
smooth1 — — source: Informix-list mailing list archive (1991-1998)

Obnoxio The Clown wrote in message <8pnlu4$gks$1@news.xmission.com>... > >From: "Neil Truby" <ntruby@netcomuk.co.uk> >> >>smooth1 <smooth1@iclway.co.uk> wrote in message >>news:39bed022_2@news1.vip.uk.com... >> > >> > >> > Oh! 16 second down to 6 with IDS 2000!! >> > >> > Surely you can prepare and execute an update stats in the >> > VB application?? We do so in 4gl applications! >> >>Well, maybe we can. But really, the question is "Why do we have to?". >>This >>is just one of a number of differences in behaviour that we're finding in >>IDS 9.20. We're not using any of the extended functionality of IDS9.20, so >>really want it to behave as v7.x did (only faster!). But we keep getting >>bitten in the arse by query plans like this. > >Well, effectively you've regressed from the 7.31 optimiser to the 7.30 >optimiser. So there could be all sorts of differences. > Oh! 9.20! I thought this was 9.21?? It is certainly available for Linux on intraware! Surely not Linux being ported to BEFORE other platforms?? _________________________________________________________________________ >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > >Share information about yourself, create your own public profile at >http://profiles.msn.com. >

Glossary