Re: can I use sum with computed by

Article View: borland.public.interbase.sql

Article #100

Back to borland.public.interbase.sql Previous Next

#100

From: Isaac
Date: Fri, 30 May 2008 15:06

15 lines
1339 bytes

Maxim Shiryaev wrote:
> Hi.
> 
> You can but it will be very inefficeint.
> 
> It's better to create triggers on detail table and update regular (not
> computed) fields in the master. De-normalisation though...
> 
> Calculated fields will be better only if you have very strange read/write
> ratio (in favour of write) for a usage senario of your database.
> 
> 
> Maxim.

ok thanks alot

Technical Details

Message-ID: <484017fa@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder.news-service.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <483c6824@newsgroups.borland.com> <483ebabf@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,f81bba07595296f5
X-Google-Attributes: gid114a0e,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Fri, 30 May 2008 18:06:28 +0300
From: Isaac <no@no.com>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: can I use sum with computed by
References: <483c6824@newsgroups.borland.com> <483ebabf@newsgroups.borland.com>
In-Reply-To: <483ebabf@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 41.234.201.208
Message-ID: <484017fa@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1212159994 41.234.201.208 (30 May 2008 08:06:34 -0700)
Lines: 15
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder.news-service.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message