Re: sql and informix

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

Article #643

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

#643

From: Romain Strieff [TeamB]
Date: Mon, 27 Jul 1998 00:00

26 lines
1189 bytes

In article <35B936BE.5E9B@medic.ukm.my>, zag@medic.ukm.my grudgingly 
admits...
> 
> It work now with this code
> 
> open database informix
> set database to informix
> select * from ptmed where ptname like 'ALI%'
> 
> but it is very slow or hanging with code
> 
> open database informix
> select * from :informix:ptmed where ptname like 'ALI%'
> 
> but it is fast to do searching with code
> 
> select * from :informix:ptmed where mrn='12345'
> 
> compare to 
> 
> select * from ptmed where mrn='12345'
> 
The slow one has to do a sequential search and check every single row for 
a match, the fast one uses indexes to do it.
-- 
Romain Strieff [TeamB]

Technical Details

Message-ID: <MPG.102697b0f885458b98b018@forums.borland.com>

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: Romain@Do.not.reply.via.e-mail (Romain Strieff [TeamB])
Subject: Re: sql and informix
Date: 1998/07/27
Message-ID: <MPG.102697b0f885458b98b018@forums.borland.com>
X-Deja-AN: 375295094
References: <35B3EBA1.35FF@medic.ukm.my> <35B429BA.F248BA80@ibm.net> <35B936BE.5E9B@medic.ukm.my>
Organization: TeamB
Reply-To: teamb@opto-pps.com
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message