From user-java-return-15446-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org Tue Oct 21 15:12:39 2008 Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 43172 invoked from network); 21 Oct 2008 15:12:39 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 21 Oct 2008 15:12:39 -0000 Received: (qmail 24742 invoked by uid 500); 21 Oct 2008 15:12:39 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 24550 invoked by uid 500); 21 Oct 2008 15:12:38 -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 24534 invoked by uid 99); 21 Oct 2008 15:12:38 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 21 Oct 2008 08:12:38 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of mike.schall@gmail.com designates 209.85.198.250 as permitted sender) Received: from [209.85.198.250] (HELO rv-out-0708.google.com) (209.85.198.250) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 21 Oct 2008 15:11:27 +0000 Received: by rv-out-0708.google.com with SMTP id b17so2203561rvf.36 for ; Tue, 21 Oct 2008 08:12:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type:references; bh=HNQX/hjf8v4+Jdt349vYGb2lZlFj+WwoCkTsSAdKyv8=; b=aricWr/oTxbqaVdbXt1RC+8cCsDAAnZEgFH+HikgxXzAQ8B0qiw3q7pnrKHO0xcTTU +vUG1bMcZjJOfKaZpy2hvvqDzq8GbbUgfPYGa2bzQmNiUWqRDblZMMrFQ1HVr9qWCp07 XO1qtc7pioZlEgjbmNErcJp32PfaqhK4qDO/A= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:references; b=RjeU7a9tdMXzWahsMPeeqnW1zhuIGsJiNAnf4TAwCGNG0tuuro1ug8shne3Ntfro7r d81vD3PM+q+lcvDSQqTaXOYwelk88kq4sEUqoAfS3z0nymuBupixMbB3fAjRvv9dHsA1 iDVGEe896Gnq0hG3rh2CRWKAUOnQo8jboVP68= Received: by 10.141.43.5 with SMTP id v5mr5719404rvj.216.1224601926251; Tue, 21 Oct 2008 08:12:06 -0700 (PDT) Received: by 10.141.87.20 with HTTP; Tue, 21 Oct 2008 08:12:06 -0700 (PDT) Message-ID: <5f9068320810210812q4308e872wee1454f464a0f936@mail.gmail.com> Date: Tue, 21 Oct 2008 10:12:06 -0500 From: "Michael Schall" To: user-java@ibatis.apache.org Subject: Re: Avoid java heap space while using iBatis In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_8062_9338603.1224601926250" References: <3BB210BC76AFA24C92269E5BE8C71E68070FAF39@PNE-HJN-MBX01.wipro.com> X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_8062_9338603.1224601926250 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Are you really using all 200,000 data points in your graphs or are you summarizing? Can you use SQL to generate summery information and graph that? On Tue, Oct 21, 2008 at 9:45 AM, Larry Meadors wrote: > Why do you think queryForList in a loop will work better? > > Larry > > > On Tue, Oct 21, 2008 at 8:30 AM, wrote: > > Hi, > > > > Our project is facing a java heap space issue while fetching the record > set > > of around 200,000. > > Using a row handler is not helpful as the same record set is being used > to > > plot a slider and three graphs on UI (Flex). > > > > increasing the heap space size is not allowed in our application as it is > a > > standard set by user. > > > > The sqlMapConfiguration has cacheModeEnabled set to true. > > > > Is there any way to optimize the record usage in iBatis? Can we use > > multiple queryForList in a loop ? If yes, how this can be achieved? > > > > Thanks & Regards > > Ankit > > > > Please do not print this email unless it is absolutely necessary. > > > > The information contained in this electronic message and any attachments > to > > this message are intended for the exclusive use of the addressee(s) and > may > > contain proprietary, confidential or privileged information. If you are > not > > the intended recipient, you should not disseminate, distribute or copy > this > > e-mail. Please notify the sender immediately and destroy all copies of > this > > message and any attachments. > > > > WARNING: Computer viruses can be transmitted via email. The recipient > should > > check this email and any attachments for the presence of viruses. The > > company accepts no liability for any damage caused by any virus > transmitted > > by this email. > > > > www.wipro.com > ------=_Part_8062_9338603.1224601926250 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Are you really using all 200,000 data points in your graphs or are you summarizing? Can you use SQL to generate summery information and graph that?

On Tue, Oct 21, 2008 at 9:45 AM, Larry Meadors <larry.meadors@gmail.com> wrote:
Why do you think queryForList in a loop will work better?

Larry


On Tue, Oct 21, 2008 at 8:30 AM,  <ankit.khujneri@wipro.com> wrote:
> Hi,
>
> Our project is facing a java heap space issue while fetching the record set
> of around 200,000.
> Using a row handler is not helpful as the same record set is being used to
> plot a slider and three graphs on UI (Flex).
>
> increasing the heap space size is not allowed in our application as it is a
> standard set by user.
>
> The sqlMapConfiguration has cacheModeEnabled set to true.
>
> Is there any way to optimize the record usage in iBatis?  Can we use
> multiple queryForList in a loop ? If yes, how this can be achieved?
>
> Thanks & Regards
> Ankit
>
> Please do not print this email unless it is absolutely necessary.
>
> The information contained in this electronic message and any attachments to
> this message are intended for the exclusive use of the addressee(s) and may
> contain proprietary, confidential or privileged information. If you are not
> the intended recipient, you should not disseminate, distribute or copy this
> e-mail. Please notify the sender immediately and destroy all copies of this
> message and any attachments.
>
> WARNING: Computer viruses can be transmitted via email. The recipient should
> check this email and any attachments for the presence of viruses. The
> company accepts no liability for any damage caused by any virus transmitted
> by this email.
>
> www.wipro.com

------=_Part_8062_9338603.1224601926250--