Path: text.usenetserver.com!out01b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!t-online.de!feeder.news-service.com!news2.euro.net!transit.news.xs4all.nl!xs4all!textnews.nntp.hccnet.nl!textreader.nntp.hccnet.nl!not-for-mail From: sybrandb@gmail.com Newsgroups: comp.databases.oracle.server Subject: Re: Caching for "LIKE" queries? Date: Tue, 20 Mar 2007 21:07:52 +0100 Message-ID: References: <1174419057.325742.139640@e1g2000hsg.googlegroups.com> X-Newsreader: Forte Agent 4.2/32.1118 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 23 Organization: Hobby Computer Club News Network NNTP-Posting-Date: 20 Mar 2007 20:08:05 GMT NNTP-Posting-Host: 62.251.43.160 X-Trace: 1174421285 textreader.nntp.hccnet.nl 743 62.251.43.160:2949 X-Complaints-To: abuse@hccnet.nl Xref: usenetserver.com comp.databases.oracle.server:424457 X-Received-Date: Tue, 20 Mar 2007 15:08:06 EST (text.usenetserver.com) On 20 Mar 2007 12:30:57 -0700, "fraserofthenight" 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