Re: rowset.FinKey() in a multicolumnar SQL Index

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

Article #168

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

#168

From: Jose Luis Perez Diez
Date: Mon, 08 Mar 1999 00:00

21 lines
1508 bytes

In article <MPG.114a002865160aeb989fb4@forums.inprise.com>, Romain Strieff [TeamB] 
wrote:
> In article <VA.00000107.052589a8@jpddb>, Jose Luis Perez Diez politely 
> paraphrased ...
> > I'm connected to an oracle database via OBDC and findkey() works for simple 
> > indexes but when I try to it with a multicolumnar index I don't get a response 
> > for a long time.
> > The Index TAG: AUT_SERIES  Key: CG_TLTJ,CL_AMBT
> >                            CG_TLTJ is VARCHAR(5)
> >                            CL_AMBT is VARCHAR(1)
> > I use finkey with code like this one:    
> > orowset.indexName := 'AUT_SERIE'
> > orowset.FindKey('MDL','1')
> > 
> Oracle and ODBC _are_ the slowest possible combination.
>
If Use findkey('MDL') for a partial match the response comes in seconds for the 
complete form I never have seen its response (I've let it run for more than 5 
hours).

Jos� Luis P�rez Diez

Technical Details

Message-ID: <VA.00000108.00e39ae2@jpddb>

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

References: <VA.00000107.052589a8@jpddb> <MPG.114a002865160aeb989fb4@forums.inprise.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: ff5a1,165fa53f4266efc9
X-Google-Attributes: gidff5a1,public
From: Jose Luis Perez Diez <NOMAIL@Jluis.es>
Subject: Re: rowset.FinKey() in a multicolumnar SQL Index
Date: 1999/03/08
Message-ID: <VA.00000108.00e39ae2@jpddb>
X-Deja-AN: 452538761
Content-Transfer-Encoding: 8bit
References: <VA.00000107.052589a8@jpddb> <MPG.114a002865160aeb989fb4@forums.inprise.com>
Content-Type: text/plain; charset=iso-8859-1
Organization: My Company
Mime-Version: 1.0
Reply-To: NOMAIL@Jluis.es
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message