Re: Displaying only certain records in a SQL

Article View: borland.public.vdbase.data.sql

Article #1267

Back to borland.public.vdbase.data.sql Previous Next

#1267

From: Bowen Moursund
Date: Wed, 25 Mar 1998 00:00

15 lines
1182 bytes

>I have a report I am trying to pull from a query but I can not get it to
>work. I used the SQL wizard but it takes forever and includes everything.

Yea, joins of local tables can be agonizingly slow. You should consider
linking the tables via indexName, masterRowset, and masterFields, rather
than joining them, or perhaps even building a temporary table if the set of
records is limited.
____
Bowen Moursund (TeamB)
bowenNOSPAM@nerds.com
http://www.mindspring.com/~bowenm/datatech.htm
Try these help resources:
 http://forumsearch.borland.com:88
 http://www.dejanews.com/home_ps.shtml

Technical Details

Message-ID: <6fclqs$jm819@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <6f9cnm$gj03@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,c1e1fa092e4d4c4d
X-Google-Attributes: gidff5a1,public
From: "Bowen Moursund" <<teamb@opto-pps.com>
Subject: Re: Displaying only certain records in a SQL
Date: 1998/03/25
Message-ID: <6fclqs$jm819@forums.borland.com>
X-Deja-AN: 337776210
Content-Transfer-Encoding: 7bit
References: <6f9cnm$gj03@forums.borland.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Organization: DataTech
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message