Re: How to improve the performance of this query?

Neuza,

Irrespective of your database, in your SELECT statement, first get rid of
A.* and D.* and explicitly specify the fields from table A and B.
This will reduce bulk of unwanted fields sent from server to client. I would
call this as your first step towards optimisation.

Warm regards,
Jatin N. Bhior

----- Original Message -----
From: "Jeff Cook" <[email protected]>
To: <[email protected]>
Sent: Tuesday, August 19, 2003 2:32 AM
Subject: RE: [Delphi] How to improve the performance of this query?


> Neuza
>
> -----Original Message-----
> From: neuzaalves [mailto:[email protected]]
> Sent: Tuesday, 19 August 2003 5:20 a.m.
> To: [email protected]
> Subject: [Delphi] How to improve the performance of this query?
>
> Hi,
>
> select A.* ,B.GPE_DESCR,C.SGE_DESCR,D.*  from EITEMBASE A ,EGRUPO
> B,ESUBGRUPO C ,EITEMBASECARAC D where A.GPE_ID=B.GPE_ID and
> C.SGE_ID=A.SGE_ID and D.ITB_ID=A.ITB_ID
> order by GPE_DESCR,SGE_DESCR,ITB_DESCR
>
> <snip>
>
> What is the best thing to do?
> -----
>
> The "best thing to do" would be to tell us which database you are using.
> My own experience is with Paradox, DBISAM and MSSQL.  In each of these,
> the most efficient way to phrase a query can be quite different.  Tell
> us which database you are using and someone with specialist knowledge
> may be able to help.  OR ... find a newsgroup for your database and ask
> the question there.
>
> Cheers
>
> Jeff



------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark
Printer at Myinks.com. Free s/h on orders $50 or more to the US & Canada. http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/i7folB/TM
---------------------------------------------------------------------~->

Delphi VCL Top Sites!
http://www.sandbrooksoftware.com/TS/TS2/Components.shtml
---------------------------------------------------------------
Unsubscribe:[email protected]
List owner:[email protected]
--------------------------------------------------------------- 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/