Article View: borland.public.vdbase.data.sql
Article #181Re: rowset.FinKey() in a multicolumnar SQL Index
From: Jose Luis Perez Diez
Date: Wed, 10 Mar 1999 00:00
Date: Wed, 10 Mar 1999 00:00
16 lines
1442 bytes
1442 bytes
In article <MPG.114f0fcd309c570f98a013@forums.inprise.com>, Romain Strieff
[TeamB] wrote:
> 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.
>
I've made some test and the best solution is to use a WHERE clause and let the
server resolve, ending with a different rowset or using filter property ,it is
fast but to revert to the full rowset its faster to use an ever true filter
condition than the use of clearfilter()
Jos� Luis P�rez Diez
Technical Details
Message-ID:
<VA.0000010b.01653b70@jpddb>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> <MPG.114f0fcd309c570f98a013@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/10 Message-ID: <VA.0000010b.01653b70@jpddb> X-Deja-AN: 453428370 Content-Transfer-Encoding: 8bit References: <VA.00000107.052589a8@jpddb> <MPG.114a002865160aeb989fb4@forums.inprise.com> <VA.00000108.00e39ae2@jpddb> <MPG.114e02499b2153dc989fed@forums.inprise.com> <VA.00000109.0068f6b8@jpddb> <MPG.114f0fcd309c570f98a013@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