Re: Caching for "LIKE" queries?

On 20 Mar 2007 12:30:57 -0700, "fraserofthenight" <fraserofthenight_at_gmail.com> wrote:

>Specifically, I'm wondering if I should implement a cache at the
>application level (or in the database, since all the queries are
>called using stored procs -- is this a good idea at all?), or whether
>the database will take care of that for me.

Apparently you are unfamiliar with some basic Oracle concepts. Oracle already has a buffer cache, you why implement one of your own? Even worse: implement one in the application layer! Stored procs are a good idea, provided they don't make use of Native Dynamic SQL.
Generally speaking in terms of Java: all statements should be Prepared.
Reading of the Oracle Concepts Manual at http://tahiti.oracle.com is mandatory for anyone who touches Oracle, together with any book by Tom Kyte if you are from a sqlserver background.

-- 
Sybrand Bakker
Senior Oracle DBA