Re: sql and informix

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

Article #638

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

#638

From: Geoff Wass
Date: Sat, 25 Jul 1998 00:00

23 lines
1427 bytes

Zainal,

I am glad it is at least working for you. I cannot explain why there is
a speed difference between the last two examples. Perhaps the BDE is
treating them differently. The speed difference of the first 2 examples
is probably Informix-based. However, you do have to expect search using
LIKE to take much longer than searches using = because LIKE cannot
necessarily take advantage of indexes or at least not to the same exent
as = or > etc.

--
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!

Report Inprise/Borland bugs!
http://www.inprise.com/devsupport/bugs/bug_reports.html
=============================================================
Triumph is in the first syllable.

Technical Details

Message-ID: <35B97591.FDB7CECF@ibm.net>

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

References: <35B3EBA1.35FF@medic.ukm.my> <35B429BA.F248BA80@ibm.net> <35B936BE.5E9B@medic.ukm.my>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,8cfa117df13ff39
X-Google-Attributes: gidff5a1,public
From: Geoff Wass <gswass@ibm.net>
Subject: Re: sql and informix
Date: 1998/07/25
Message-ID: <35B97591.FDB7CECF@ibm.net>
X-Deja-AN: 374738418
Content-Transfer-Encoding: 7bit
References: <35B3EBA1.35FF@medic.ukm.my> <35B429BA.F248BA80@ibm.net> <35B936BE.5E9B@medic.ukm.my>
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