Article View: borland.public.vdbase.data.sql
Article #174Re: rowset.FinKey() in a multicolumnar SQL Index
From: Romain Strieff [TeamB]
Date: Tue, 09 Mar 1999 00:00
Date: Tue, 09 Mar 1999 00:00
21 lines
1390 bytes
1390 bytes
In article <VA.00000109.0068f6b8@jpddb>, Jose Luis Perez Diez politely
paraphrased ...
> > Mmm, not sure if I understand the above, does it come within seconds when
> > running local and hours when running offsite?
> >
> Both finkey are running in server. I suspect that findkey only works for single
> key or expression indexes.
>
Did you try with <rowset>applylocate("Name='Doe' and city='Los Angeles'")
if not, try with and without an active index to see if there's a
difference.
But it should be fastest if you'd use the WHERE clause of the SQL
property, or perhaps PARAMS depending on your needs.
--
Romain Strieff [TeamB]
Please read this newsgroup guide below before
posting on the private Inprise newsgroups.
http://www.inprise.com/newsgroups/guide.html
--
Technical Details
Message-ID:
<MPG.114f0fcd309c570f98a013@forums.inprise.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<VA.00000107.052589a8@jpddb> <MPG.114a002865160aeb989fb4@forums.inprise.com> <VA.00000108.00e39ae2@jpddb> <MPG.114e02499b2153dc989fed@forums.inprise.com> <VA.00000109.0068f6b8@jpddb>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,165fa53f4266efc9 X-Google-Attributes: gidff5a1,public From: teamb@opto-pps.com (Romain Strieff [TeamB]) Subject: Re: rowset.FinKey() in a multicolumnar SQL Index Date: 1999/03/09 Message-ID: <MPG.114f0fcd309c570f98a013@forums.inprise.com> X-Deja-AN: 452919934 References: <VA.00000107.052589a8@jpddb> <MPG.114a002865160aeb989fb4@forums.inprise.com> <VA.00000108.00e39ae2@jpddb> <MPG.114e02499b2153dc989fed@forums.inprise.com> <VA.00000109.0068f6b8@jpddb> Organization: TeamB Newsgroups: borland.public.vdbase.data.sql