Re: LIKE performance

From: GreyBeard <Fuzzy.GreyBeard_at_gmail.com>
Date: Thu, 24 Feb 2005 23:47:36 GMT
Message-Id: <pan.2005.02.25.00.48.10.865706@gmail.com>

On Fri, 25 Feb 2005 09:43:15 +1000, lh wrote:

>>
>> Depending on the version of Oracle, and the frequency of the specific
>> query, you might consider a funcion based index.
>>
>> However, you leave us with far too little info to go beyond smarmy 
>> guesses.
>>
>> FGB

>
>
> My smarmy apologies your Greybeardness.

Sorry 'bout that. I never should type what I'm thinking <g>

> Oracle 8i, the query is executed in a loop, the function is reading
> directories for files then checking the table to check that the file has
> been logged. The function is run regularly and with 10s of thousands of
> files it is taking way too long. This query is the bottleneck with a
> few seconds per query the current time. So I need a faster way to check
> for filenames in the table.

Whatcha doing with the files? IOW, is there a way that intermedia could help you, or the content management SDK?

As a first shot, though, I'd try a fbi.

FGB Received on Thu Feb 24 2005 - 17:47:36 CST