Hi , I have the large amount of data in the database. It is approximately 2 lakh 80 thousand records in the dynamically created tables. I have the method in session bean which query the database and get the values and put in a hash table in 30 seconds. I am calling this method from java client which takes 10 minutes to complete.So tranferring the huge amount of data in hash table takes so much time. Is there any way to reduce this data transfer time ?
posted 10 years ago
In my opinion using ejbs for transferring large amount of data is not the best choice. You can use third-party software tools for that and I�d recommend you looking at openadaptor:
The beauty of it is that you don�t need to write any code for that, providing an appropriate configuration file will suffice. Another advantage is that you can configure the tool to transfer several smaller chunks of data at a time, rather than a giant load. It has also other nice features like message hospitals, etc. Regards.