Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 1225 invoked from network); 21 Jul 2005 21:19:36 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 21 Jul 2005 21:19:36 -0000 Received: (qmail 93155 invoked by uid 500); 21 Jul 2005 21:19:35 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 93126 invoked by uid 500); 21 Jul 2005 21:19:34 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 93113 invoked by uid 99); 21 Jul 2005 21:19:34 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 21 Jul 2005 14:19:34 -0700 X-ASF-Spam-Status: No, hits=1.8 required=10.0 tests=RCVD_IN_BL_SPAMCOP_NET X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [192.18.98.34] (HELO brmea-mail-3.sun.com) (192.18.98.34) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 21 Jul 2005 14:19:28 -0700 Received: from esunmail ([129.147.156.34]) by brmea-mail-3.sun.com (8.12.10/8.12.9) with ESMTP id j6LLJWvU003005 for ; Thu, 21 Jul 2005 15:19:32 -0600 (MDT) Received: from xpa-fe1 (esunmail [129.147.156.34]) by edgemail1.Central.Sun.COM (iPlanet Messaging Server 5.2 HotFix 2.02 (built Oct 21 2004)) with ESMTP id <0IJZ00LL4XWJRF@edgemail1.Central.Sun.COM> for user-java@ibatis.apache.org; Thu, 21 Jul 2005 15:19:32 -0600 (MDT) Received: from [129.147.48.179] by mail.sun.net (iPlanet Messaging Server 5.2 HotFix 2.02 (built Oct 21 2004)) with ESMTPSA id <0IJZ000AAXWJFU@mail.sun.net> for user-java@ibatis.apache.org; Thu, 21 Jul 2005 15:19:31 -0600 (MDT) Date: Thu, 21 Jul 2005 15:19:39 -0600 From: Nathan Maves Subject: Estimating amount of memory need for cache To: user-java@ibatis.apache.org Message-id: <8A9C57F4-4F4D-48B4-B555-7B65D5EA6766@sun.com> MIME-version: 1.0 X-Mailer: Apple Mail (2.733) Content-type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Content-transfer-encoding: 7BIT X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N What is the best and most accurate way to calculate the space needed to cache a query. Say I have a query that returns 5 strings on average of 20 chars each. The query returns 5000 rows. I know this seems high but just humor me and remember I have access to big servers here at Sun :) Nathan