wood burning stoves 2.0*
The moose likes JDBC and the fly likes How to reduce the response time when querying the Database ... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to reduce the response time when querying the Database ..." Watch "How to reduce the response time when querying the Database ..." New topic
Author

How to reduce the response time when querying the Database ...

Raza Mohd
Ranch Hand

Joined: Jan 20, 2010
Posts: 247

hi all,

I am using Ejb 3.0 in my Application with back End MySQL 5.0

I am working on a bank reconcilation Module where a file of about 20 lacks record is uploaded.

which is validated with database and then inserted .

it took almost 20 lacks queries to insert data..

It take a lot of tym to upload that Huge Amount of Data..

Can anybody tell me the way How can i Reduce the performance tym...




Thanks n Regards
Raza


Good luck!!
A small leak can sink a Gigantic ship.>
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

ORMs are generally a poor choice for performing bulk data uploads. You can tune them a bit for bulk operations (see the documentation of whatever your JPA provider is) but is speed is key, I would look at the bulk load tools that come with your database.

("lacks" == 100000, yes?)


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Raza Mohd
Ranch Hand

Joined: Jan 20, 2010
Posts: 247

thanks..

I am using Hibernate as JPA provider..

So what will be the better option..?

You mean to say that ORMs are not good as far as performance is considered??
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336


I am using Hibernate as JPA provider..

Have a look at the docs for what you can do about bulk operations.


You mean to say that ORMs are not good as far as performance is considered??

Not for bulk loading, but then that is not what they are designed for.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to reduce the response time when querying the Database ...
 
Similar Threads
java.lang.OutOfMemoryError: Java heap space
reducing load on server
displaying large number of records in a Jsp page
Tax Saving
How can i run a particular code for every 10 minutes