🚀 go-pugleaf

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. 
-- 
Romain Strieff [TeamB]
Please read this newsgroup guide below before 
posting on the private Inprise newsgroups.
http://www.inprise.com/newsgroups/guide.html
--

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

In article <VA.00000108.00e39ae2@jpddb>, Jose Luis Perez Diez politely 
paraphrased ...
> 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).
--
Mmm, not sure if I understand the above, does it come within seconds when 
running local and hours when running offsite?
-- 
Romain Strieff [TeamB]
Please read this newsgroup guide below before 
posting on the private Inprise newsgroups.
http://www.inprise.com/newsgroups/guide.html
--

In article <MPG.114e02499b2153dc989fed@forums.inprise.com>, Romain Strieff 
[TeamB] wrote:
> 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. 

Jos� Luis P�rez Diez

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

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