Re: HELP!! DBASE + SQL = WAY TOO SLOW!!!

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

Article #765

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

#765

From: Geoff Wass
Date: Tue, 14 Jul 1998 00:00

32 lines
1748 bytes

Steve,

Is this for a report or an online program? If it is for an online
program, then don't use SQL with dBASE tables at all. Even with reports
it is not necessary, but definitely do not use SQL with dBASE tables in
an online program.

Instead, use the Master-Detail linking described in the online help.
This is much faster! In fact, the larger the table the better
Master-Detail linking beats SQL joins (with dBASE tables). It also
guarantees that the resulting data is modifiable. SQL on dBASE tables
frequently results in result sets (rowsets) that are read-only.

Master-Detail linking will bring back data one [master] record at a
time... which is better than what you are requesting.

SQL is best used on client-server databases like InterBase or Oracle or
Informix (etc.). They are optimized for this type of query. dBASE tables
are suited to master-detail linking.

--
Geoff Wass
Kuala Lumpur, Malaysia


=============================================================
Please respond to a newsgroup posting by posting a reply (not e-mail).
In this way, all can help and all can learn!


=============================================================
Triumph is in the first syllable.

Technical Details

Message-ID: <35AACA1A.63A0CDCF@ibm.net>

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

References: <6odq40$2br3@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,df2ee0fbdac9fd39
X-Google-Attributes: gidff5a1,public
From: Geoff Wass <gswass@ibm.net>
Subject: Re: HELP!! DBASE + SQL = WAY TOO SLOW!!!
Date: 1998/07/14
Message-ID: <35AACA1A.63A0CDCF@ibm.net>
X-Deja-AN: 371207671
Content-Transfer-Encoding: 7bit
References: <6odq40$2br3@forums.borland.com>
Content-Type: text/plain; charset=us-ascii
Organization: Noordindarus Consultancy Sdn. Bhd.
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message