Re: iBATS & CGLIB

[Pradheep]

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: 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]  l: 00 91 44 39125333 m: 00 91 94862 08089