Return-Path: Delivered-To: apmail-db-ojb-user-archive@www.apache.org Received: (qmail 79928 invoked from network); 27 Aug 2004 06:55:14 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 27 Aug 2004 06:55:14 -0000 Received: (qmail 20062 invoked by uid 500); 27 Aug 2004 06:55:10 -0000 Delivered-To: apmail-db-ojb-user-archive@db.apache.org Received: (qmail 20041 invoked by uid 500); 27 Aug 2004 06:55:09 -0000 Mailing-List: contact ojb-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "OJB Users List" Reply-To: "OJB Users List" Delivered-To: mailing list ojb-user@db.apache.org Received: (qmail 20019 invoked by uid 99); 27 Aug 2004 06:55:09 -0000 X-ASF-Spam-Status: No, hits=-2.8 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [209.237.227.194] (HELO minotaur.apache.org) (209.237.227.194) by apache.org (qpsmtpd/0.27.1) with SMTP; Thu, 26 Aug 2004 23:55:06 -0700 Received: (qmail 79894 invoked from network); 27 Aug 2004 06:55:05 -0000 Received: from localhost.hyperreal.org (HELO ?127.0.0.1?) (127.0.0.1) by localhost.hyperreal.org with SMTP; 27 Aug 2004 06:55:05 -0000 Message-ID: <412EDAE2.1090406@apache.org> Date: Fri, 27 Aug 2004 08:55:30 +0200 From: Armin Waibel User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: OJB Users List Subject: Re: OJB performance goes down References: <200408261630.22632.Sashi.Ramaswamy@rosettawireless.com> In-Reply-To: <200408261630.22632.Sashi.Ramaswamy@rosettawireless.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Rating: localhost.hyperreal.org 1.6.2 0/1000/N X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Hi Sashi, > Say I have 100 records in the table, I do a retrieve and update on each record > every 15 seconds. could you discribe a little more detailed? How does the object + repository data look like - plain object, object with reference, ... Did you check the row count of the table after running your test (there could be a problem with update when "Mapping Classes on Multiple Joined Tables")? Which api do you use? How does the test code look like? regards, Armin Sashi Ramaswamy wrote: > Hi, > > I am using Persistence Broker API in OJB v 1.0.rc6. > I have been noticing that when I keep my application up for a while, updates > to the database slow down considerably. My application does continuous > retrieves and updates on records in a table. > To illustrate with an example, > Say I have 100 records in the table, I do a retrieve and update on each record > every 15 seconds. > On starting the application the whole scan and update takes about 7 seconds. > If I leave the application running for more than an hour it starts taking > around 20 seconds for each run and thereafter the time goes up almost > exponentially. So, if I leave the app running overnight my scan and update > process takes approx 180 seconds to complete. > > I am totally perplexed as to what could be causing this increase in time. Any > insights are welcome. > > Thanks for your help. > Sashi > > --------------------------------------------------------------------- > To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org > For additional commands, e-mail: ojb-user-help@db.apache.org > > > --------------------------------------------------------------------- To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org For additional commands, e-mail: ojb-user-help@db.apache.org