You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Pradheep <pr...@appliedevelopment.com> on 2006/07/12 06:46:34 UTC

iBATS & CGLIB

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

Re: iBATS & CGLIB

Posted by Clinton Begin <cl...@gmail.com>.
Wow.

On 7/11/06, Pradheep <pr...@appliedevelopment.com> wrote:
>
>  Clinton
>
> Thanks for your suggestion and now tried using Batch Process.
> 5000 records and its 2696 msecs.
>
> Regards
> Pradheep
>
> ----- Original Message -----
> *From:* Clinton Begin <cl...@gmail.com>
> *To:* user-java@ibatis.apache.org
> *Sent:* Wednesday, July 12, 2006 10:28 AM
> *Subject:* Re: iBATS & CGLIB
>
>
> 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 <pr...@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
> >
>
>

Re: iBATS & CGLIB

Posted by Pradheep <pr...@appliedevelopment.com>.
Clinton

Thanks for your suggestion and now tried using Batch Process.
5000 records and its 2696 msecs.

Regards
Pradheep
  ----- Original Message ----- 
  From: Clinton Begin 
  To: user-java@ibatis.apache.org 
  Sent: Wednesday, July 12, 2006 10:28 AM
  Subject: Re: iBATS & CGLIB



  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: 

    a.. We're talking 111 seconds for 5000 records, which is an about 0.0222 seconds -- pretty darn fast. 
    b.. Furthermore, it looks like it's scaling linearly, which is a good thing.
    c.. I don't think CGLIB will help you. 
    d.. Ensuring that you're managing transactions efficiently is key (although 5000+ records may be too big for many transaction logs).
    e.. 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 <pr...@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

Re: iBATS & CGLIB

Posted by Clinton Begin <cl...@gmail.com>.
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 <pr...@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
>