Article View: borland.public.interbase.sql
Article #768Re: Computed fields
From: Wayne Niddery [TeamB]
Date: Wed, 27 Jun 2007 15:32
Date: Wed, 27 Jun 2007 15:32
17 lines
1893 bytes
1893 bytes
Brian Ellul wrote: > Are there any speed issues with having computed fields in tables? As long as you are computing values from fields within the record being selected there shouldn't be. However it's possible to select from other tables, e.g. you could add a computed field in an Order record that sums the amounts from all its OrderLine records. That means, on selecting that field from Orders, IB will be performing that additional query for every selected Order row. -- Wayne Niddery - Winwright, Inc (www.winwright.ca) "If there is any principle of the Constitution that more imperatively calls for attachment than any other, it is the principle of free thought � not free thought for those who agree with us, but freedom for the thought that we hate." - Oliver Wendell Holmes
Technical Details
Message-ID:
<46828329$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!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:
<4680da48@newsgroups.borland.com> <46825418$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,eaa295f7e4d91326 X-Google-Attributes: gid114a0e,public,usenet X-Google-Language: ENGLISH,ASCII Reply-To: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca> From: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca> Newsgroups: borland.public.interbase.sql References: <4680da48@newsgroups.borland.com> <46825418$1@newsgroups.borland.com> Subject: Re: Computed fields Date: Wed, 27 Jun 2007 11:32:58 -0400 Lines: 19 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3138 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 X-RFC2646: Format=Flowed; Response NNTP-Posting-Host: 69.17.170.228 Message-ID: <46828329$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1182958377 69.17.170.228 (27 Jun 2007 08:32:57 -0700) X-Authenticated-User: wniddery Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!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