Return-Path: Delivered-To: apmail-cayenne-user-archive@www.apache.org Received: (qmail 63922 invoked from network); 5 Jul 2008 15:58:07 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 5 Jul 2008 15:58:07 -0000 Received: (qmail 83942 invoked by uid 500); 5 Jul 2008 15:58:08 -0000 Delivered-To: apmail-cayenne-user-archive@cayenne.apache.org Received: (qmail 83928 invoked by uid 500); 5 Jul 2008 15:58:08 -0000 Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cayenne.apache.org Delivered-To: mailing list user@cayenne.apache.org Received: (qmail 83917 invoked by uid 99); 5 Jul 2008 15:58:07 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 05 Jul 2008 08:58:07 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [208.78.103.231] (HELO vorsha.objectstyle.org) (208.78.103.231) by apache.org (qpsmtpd/0.29) with SMTP; Sat, 05 Jul 2008 15:57:16 +0000 Received: (qmail 17650 invoked from network); 5 Jul 2008 15:57:37 -0000 Received: from unknown (HELO ?IPv6:::1?) (127.0.0.1) by localhost with SMTP; 5 Jul 2008 15:57:37 -0000 Message-Id: From: Andrus Adamchik To: user@cayenne.apache.org In-Reply-To: <3A48F8AA-CCF0-4976-BD04-D90A43F2D489@ish.com.au> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v926) Subject: Re: estimating proper object cache size Date: Sat, 5 Jul 2008 18:57:35 +0300 References: <89FCCAB0-74D1-4FB5-BADA-CE59A2B6C852@gmail.com> <8B074469-D825-4862-A63B-BCF1B495CAAB@objectstyle.org> <3A48F8AA-CCF0-4976-BD04-D90A43F2D489@ish.com.au> X-Mailer: Apple Mail (2.926) X-Virus-Checked: Checked by ClamAV on apache.org On Jul 5, 2008, at 4:43 PM, Aristedes Maniatis wrote: > The query cache is designed to improve performance of SelectQueries > returning large result sets Query result cache and object cache are two separate caches. So the docs are correct... at least the quoted text. > What do you mean here by 'creating updates'? Two things: 1. We need to know which columns have changed 2. When optimistic locking is used, we need to know old values for the "locked" columns. Andrus