ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Clinton Begin" <clinton.be...@gmail.com>
Subject Re: iBATS & CGLIB
Date Wed, 12 Jul 2006 14:13:31 GMT
Wow.

On 7/11/06, Pradheep <pradheep.ayyanar@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 <clinton.begin@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 <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
> >
>
>

Mime
View raw message