Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 20381 invoked from network); 25 Aug 2005 06:51:08 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 25 Aug 2005 06:51:08 -0000 Received: (qmail 72812 invoked by uid 500); 25 Aug 2005 06:51:07 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 72481 invoked by uid 500); 25 Aug 2005 06:51:06 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 72468 invoked by uid 99); 25 Aug 2005 06:51:05 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 24 Aug 2005 23:51:05 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of ksunithaghm@gmail.com designates 64.233.170.205 as permitted sender) Received: from [64.233.170.205] (HELO rproxy.gmail.com) (64.233.170.205) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 24 Aug 2005 23:51:21 -0700 Received: by rproxy.gmail.com with SMTP id i8so273065rne for ; Wed, 24 Aug 2005 23:51:02 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:user-agent:x-accept-language:mime-version:to:subject:references:in-reply-to:content-type:content-transfer-encoding; b=YcLXeUib2OQBqh+UWst1j4k8HWkVBoHe0j1nIuwySs8h2il3nvFBL3SQ8U15L2NKMQ6jwitHz6hiM4ETdsIrnpO/3Er1aLe0lcAOe+8U6767sww/yo45hPIRjaZc8Ol5Zw1Pp3ONKlOe7+YoNOXsSKHFTTQzlyVpzOLvjbzOeAY= Received: by 10.39.3.28 with SMTP id f28mr904118rni; Wed, 24 Aug 2005 23:51:02 -0700 (PDT) Received: from ?67.121.171.162? ( [67.121.171.162]) by mx.gmail.com with ESMTP id 3sm1832402rnr.2005.08.24.23.51.01; Wed, 24 Aug 2005 23:51:02 -0700 (PDT) Message-ID: <430D6A40.80707@gmail.com> Date: Wed, 24 Aug 2005 23:50:40 -0700 From: Sunitha Kambhampati User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Discussion Subject: Re: BLOB performence References: <1124855839.22088.ezmlm@db.apache.org> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-15; 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 Rajes Akkineni wrote: > When i tried to place 1000 64kb blobs it took more then 120 sec. > But when i removed the blob i can execute 9,00,00,000 inserts in just > 3 sec. > The 90 million number seems really high to me, could it be possible that your test may not be actually performing inserts ..? what row size are you inserting here.. It is always a good idea to include machine configuration, jvm used when giving out numbers. On one of my test machines ( win2k, 2cpu -intel xeon, 2.4ghz, 4gb ram, with disk cache) , jdk1.5 - similar test as you describe for blob inserts is approximately five times faster than what you report. Sunitha.