Article View: borland.public.interbase.opensource
Article #358Re: Really Slow Delete on an System
From: Jarek Bialik
Date: Mon, 08 Nov 2004 17:01
Date: Mon, 08 Nov 2004 17:01
21 lines
1609 bytes
1609 bytes
Hi Bill, thanks for your response, Unfortunately that "date" column is actually stored as Varchar(10), so it needs a type cast. The Select will return about ~3500 rows. So does the subquery execute for every row in the delete query? Shouldnt the select sub query execute only once? Thanks Jarek Bialik Britec Computer Consultanting "Bill Todd" <no@no.com> wrote in message news:418c1939$1@newsgroups.borland.com... > Why do you need to cast the value from the inqDate column? What is its > data type? > > How many rows does the SELECT return? > > -- > Bill (TeamB) > TeamB cannot answer questions received via email
Technical Details
Message-ID:
<418fa654@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!proxad.net!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<418c133c$1@newsgroups.borland.com> <418c1939$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 106772,edefe87e3c53cf5d X-Google-Attributes: gid106772,public X-Google-Language: ENGLISH,ASCII-7-bit From: "Jarek Bialik" <jbialik@telusplanet.net> Newsgroups: borland.public.interbase.opensource References: <418c133c$1@newsgroups.borland.com> <418c1939$1@newsgroups.borland.com> Subject: Re: Really Slow Delete on an System Date: Mon, 8 Nov 2004 10:01:09 -0700 Lines: 23 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; Original NNTP-Posting-Host: 199.126.21.55 Message-ID: <418fa654@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1099933268 199.126.21.55 (8 Nov 2004 09:01:08 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!proxad.net!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail