Article View: borland.public.interbase.sql
Article #62Re: speedup stored procedure
From: Bill Todd [TeamB]
Date: Mon, 26 May 2008 19:14
Date: Mon, 26 May 2008 19:14
9 lines
1447 bytes
1447 bytes
Since the procedure is a long series of SELECTs the only way to improve performance is to improve the performance of the individual SELECT statements. Download a copy of InterBase Planalyzer (free). Read the help file then analyze the performance of each SELECT and see if you can improve it using the information in the help file and the information provided by IB Planalyzer. -- Bill Todd (TeamB)
Technical Details
Message-ID:
<483b0bfe$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news1.google.com!news.glorb.com!feeder.erje.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<483af1a3@newsgroups.borland.com> <483afcd1$1@newsgroups.borland.com> <483b0303@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,bbbc202de7cd9140
X-Google-Attributes: gid114a0e,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bill Todd [TeamB]" <no@no.com>
Subject: Re: speedup stored procedure
Newsgroups: borland.public.interbase.sql
References: <483af1a3@newsgroups.borland.com> <483afcd1$1@newsgroups.borland.com> <483b0303@newsgroups.borland.com>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.18.1.9
X-Face: ":yn4zt^A_dn>6~{YJmu^B\'4w)e:apPM\VC=Dvf&*tASxX9|BYczkFd$xr.$vNSZ[3Uobr p]c4\+\l){!WQI.$]veP({HLd;CDYH?iN
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 63.147.41.232
Message-ID: <483b0bfe$1@newsgroups.borland.com>
Date: 26 May 2008 12:14:06 -0700
X-Trace: newsgroups.borland.com 1211829246 63.147.41.232 (26 May 2008 12:14:06 -0700)
Lines: 9
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news1.google.com!news.glorb.com!feeder.erje.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail