Re: Extreamly cpu intensive query

Article View: borland.public.interbase.sql

Article #264

Back to borland.public.interbase.sql Previous Next

#264

From: Mikael
Date: Tue, 29 Jan 2008 14:48

19 lines
1544 bytes


> Check the fetch statistics. The subqueries are correlated. Hence, lots
> of fetching, lots of sorting.

I always thougt this conserned I/O not Cpu. But sorting in memory maybe 
does?

>
> Use GROUP BY / HAVING instead, if possible, a stored proc if not.

Hmm intresting. can you please develop that?

>
> -- 
> Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH
>  Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
> Want to help make Delphi and InterBase better?  Use QC!
>  http://qc.borland.com -- Vote for important issues

Technical Details

Message-ID: <479f3cda$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsgate.cistron.nl!xs4all!news2.euro.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <479f1acb@newsgroups.borland.com> <479f37d1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,5debdf074bd6e927
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII
From: "Mikael" <mikael.nilsson@put.com>
Newsgroups: borland.public.interbase.sql
References: <479f1acb@newsgroups.borland.com> <479f37d1@newsgroups.borland.com>
Subject: Re: Extreamly cpu intensive query
Date: Tue, 29 Jan 2008 15:48:58 +0100
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: 217.150.160.139
Message-ID: <479f3cda$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1201618138 217.150.160.139 (29 Jan 2008 06:48:58 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsgate.cistron.nl!xs4all!news2.euro.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message