🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.sql
Article #767

Re: Computed fields

#767
From: Craig Stuntz TeamB
Date: Wed, 27 Jun 2007 12:53
15 lines
1507 bytes
Brian Ellul wrote:

> Are there any speed issues with having computed fields in tables?

	No, although we keep them simple (e.g., concatenations).
 
> How does it work? Is the field computed only when selected?

	Yes.

-- 
Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH
  Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
Useful articles about InterBase development:
  http://blogs.teamb.com/craigstuntz/category/21.aspx
Technical Details
Message-ID: <46825dd6@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail
References: <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
From: "Craig Stuntz [TeamB]" <craig_stuntz@nospam.please [a.k.a. acm.org]>
Subject: Re: Computed fields
Newsgroups: borland.public.interbase.sql
References: <4680da48@newsgroups.borland.com> <46825418$1@newsgroups.borland.com>
Organization: Vertex Systems Corporation
User-Agent: XanaNews/1.18.1.5
X-Face: "huzh55Xi]!ZNni78>a*5+).`SK?<^q2MlHk-C]Z2M9T@\J5ZCB$95Ey+s"XQuhGFA[eutZ:0^AV!Q;t>gE`1-=8d;HZ6~*o1dH<X9\b$!|(}+I'!Xq)@3Op}%0ArW&nf'Qh*EwR
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 24.106.104.205
Message-ID: <46825dd6@newsgroups.borland.com>
Date: 27 Jun 2007 05:53:42 -0700
X-Trace: newsgroups.borland.com 1182948822 24.106.104.205 (27 Jun 2007 05:53:42 -0700)
Lines: 15
X-Authenticated-User: cstuntz
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail