Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 11509 invoked from network); 12 Jul 2006 04:58:48 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 12 Jul 2006 04:58:48 -0000 Received: (qmail 99266 invoked by uid 500); 12 Jul 2006 04:58:48 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 98728 invoked by uid 500); 12 Jul 2006 04:58:46 -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 98717 invoked by uid 99); 12 Jul 2006 04:58:46 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 11 Jul 2006 21:58:46 -0700 X-ASF-Spam-Status: No, hits=0.6 required=10.0 tests=DNS_FROM_RFC_ABUSE,HTML_MESSAGE,HTML_TAG_EXIST_TBODY,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of clinton.begin@gmail.com designates 66.249.92.171 as permitted sender) Received: from [66.249.92.171] (HELO ug-out-1314.google.com) (66.249.92.171) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 11 Jul 2006 21:58:45 -0700 Received: by ug-out-1314.google.com with SMTP id a2so130616ugf for ; Tue, 11 Jul 2006 21:58:24 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=Hhtl+2WsblzQW/ZA6ReWPWOLwKHDfg2Fg6Ri4HFBTBUtz9uahRgHyOP9Jrg/qE3bjyO6EbAhQKtbC++dTblFU4BjrtL33/8PQEveOuGd/WvBzbiG4cQhlkPj3ejWt17w7MHm+2RLwwvAyg3qF5lK7Leyi4TMRa5W4m+5GJunMG4= Received: by 10.78.177.3 with SMTP id z3mr140521hue; Tue, 11 Jul 2006 21:58:24 -0700 (PDT) Received: by 10.78.135.18 with HTTP; Tue, 11 Jul 2006 21:58:24 -0700 (PDT) Message-ID: <16178eb10607112158n36a821b0j1e53a2c6aa89fb7a@mail.gmail.com> Date: Tue, 11 Jul 2006 22:58:24 -0600 From: "Clinton Begin" To: user-java@ibatis.apache.org Subject: Re: iBATS & CGLIB In-Reply-To: <006e01c6a56e$2742c270$0601a8c0@ADdomain.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_24482_22543938.1152680304119" References: <006e01c6a56e$2742c270$0601a8c0@ADdomain.com> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N ------=_Part_24482_22543938.1152680304119 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Can you explain the timings? Certainly it didn't take 31 hours to insert the records! I understand that in some countries the comma (",") is used where I would use a decimal ("."). So if my understanding is correct: - We're talking 111 seconds for 5000 records, which is an about 0.0222seconds -- pretty darn fast. - Furthermore, it looks like it's scaling linearly, which is a good thing. - I don't think CGLIB will help you. - Ensuring that you're managing transactions efficiently is key (although 5000+ records may be too big for many transaction logs). - Batch updates will probably help you. Here's a related post: http://www.mail-archive.com/user-java@ibatis.apache.org/msg04760.html Cheers, Clinton On 7/11/06, Pradheep wrote: > > Dear > > i am inserting some 5000 records and the table has only 2 columns with the > id and name where id is autoincremented and name is also added with the auto > number [say pradheep+i] > i just checked a sample of 5000 records and the time it took vaires > accordingly > Inserting 5000 records 111,765 secs > Inserting 5000 records 111,750Sec > Inserting 5000 records 109,766Sec > Inserting 10000 records 201,812 secs > > so when compared, its toooo slow. how do i improve my performance. can you > suggest me on how to use this. > > or else > > when reading the document of SQL Map, they were talking about CGLIB. so i > have downloaded that and added to my project. > how do i work with CGLIB if needed. > > URGENT... > > Regards > * P R A D H E E P* *A P P L I E D D E V E L O P M E N T * Team > Leader > Chennai, India > e: pradheep.ayyanar@appliedevelopment.com > l: 00 91 44 39125333 > m: 00 91 94862 08089 > ------=_Part_24482_22543938.1152680304119 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Can you explain the timings?  Certainly it didn't take 31 hours to insert the records! I understand that in some countries the comma (",") is used where I would use a decimal (".").  So if my understanding is correct:
  • We're talking 111 seconds for 5000 records, which is an about 0.0222 seconds -- pretty darn fast. 
  • Furthermore, it looks like it's scaling linearly, which is a good thing.
  • I don't think CGLIB will help you.
  • Ensuring that you're managing transactions efficiently is key (although 5000+ records may be too big for many transaction logs).
  • Batch updates will probably help you.
Here's a related post:

http://www.mail-archive.com/user-java@ibatis.apache.org/msg04760.html

Cheers,
Clinton

On 7/11/06, Pradheep <pradheep.ayyanar@appliedevelopment.com> wrote:
Dear
 
i am inserting some 5000 records and the table has only 2 columns with the id and name where id is autoincremented and name is also added with the auto number [say pradheep+i]
i just checked a sample of 5000 records and the time it took vaires accordingly
Inserting 5000 records 111,765 secs
Inserting 5000 records 111,750Sec
Inserting 5000 records 109,766Sec
Inserting 10000 records 201,812 secs
 
so when compared, its toooo slow. how do i improve my performance. can you suggest me on how to use this.
 
or else
 
when reading the document of SQL Map, they were talking about CGLIB. so i have downloaded that and added to my project.
how do i work with CGLIB if needed.
 
URGENT...
 
Regards
 P R A D H E E P A P P L I E D    D E V E L O P M E N T 
Team Leader
Chennai, India
e: pradheep.ayyanar@appliedevelopment.com
 l: 00 91 44 39125333
m: 00 91 94862 08089

------=_Part_24482_22543938.1152680304119--