Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (herse.apache.org: local policy)
Message-ID: <45F52917.2070404@elfyard.com>
Date: Mon, 12 Mar 2007 12:19:03 +0200
From: Valentin Cozma <vcozma@elfyard.com>
User-Agent: Thunderbird 1.5.0.8 (X11/20061117)
MIME-Version: 1.0
To: derby-user@db.apache.org
Subject: Derby problem 
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Dear all,

I am using derby version 10.2.2.0 .
One of my clients ( the one with the largest database, around 70 MB ) 
has the following problem :

- tries to add something into the application, the application does the 
job in about 5-10 minutes. It is a very simple task and should take less 
than 1 second. It adds a receipt in the database. Processor is 100 % used.
- after deleting all the receipts, the application performs the same 
operation normally.

I checked the application , I seems correct.
I checked on windows and linux, no permission problems.
Other sections of the applications perform correctly.
I checked in both embedded and network server mode, same problem.
I checked with the debugger, the most "used" code is in Derby, something 
like "PlainSocket" .

Questions :
- Anybody had a similar problem ?
- Is this related to the size of the database ?
- Does it seem like a bug in Derby ?

I can provide the database if required.

Thank you !