Article View: borland.public.interbase.sql
Article #527Re: Using EXISTS in views crashed IB (6.0)??
From: Arjan de Haan
Date: Wed, 14 Nov 2007 21:51
Date: Wed, 14 Nov 2007 21:51
18 lines
1869 bytes
1869 bytes
"Arno Brinkman" <bnewsgroups @ REMOVE_ME abvisie.nl> schreef in bericht news:473aff1f$1@newsgroups.borland.com... > Hi, > > You could try a workaround by bringing the view into the from clause. > May be the crash is related to view in the EXISTS. > Well, that sort of works. Although retrieving the plan still crashes IB, running the query produces an 'overflow during data type conversion' error. And after that, the plan can be seen too! Funny (actually, NOT). About the performance: in the original query there would be about 42 records retrieved from the Locaties table. Now: over 1800 non-indexed and over 1900 indexed reads. It's a start. I try to rework the original query/view to your suggestion. ...Arjan...
Technical Details
Message-ID:
<473b6dff@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!feeder.erje.net!tudelft.nl!txtfeed1.tudelft.nl!feeder.news-service.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<473a11f4@newsgroups.borland.com> <473abb2c@newsgroups.borland.com> <473af3ed$1@newsgroups.borland.com> <473aff1f$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,2745675ecdb62401 X-Google-Attributes: gid114a0e,public,usenet X-Google-Language: ENGLISH,ASCII-7-bit From: "Arjan de Haan" <2x nospam nospam adwhaan AT hotpop.com> Newsgroups: borland.public.interbase.sql References: <473a11f4@newsgroups.borland.com> <473abb2c@newsgroups.borland.com> <473af3ed$1@newsgroups.borland.com> <473aff1f$1@newsgroups.borland.com> Subject: Re: Using EXISTS in views crashed IB (6.0)?? Date: Wed, 14 Nov 2007 22:51:25 +0100 Lines: 20 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Response NNTP-Posting-Host: 82.170.245.232 Message-ID: <473b6dff@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1195077119 82.170.245.232 (14 Nov 2007 13:51:59 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!feeder.erje.net!tudelft.nl!txtfeed1.tudelft.nl!feeder.news-service.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail