Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Webservice/EJB  RSS feed

 
Mabobotsane Mogo
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

I need to send data from one database to another. I used webservice to expose methods to external source to pull (one transaction at the time) from my database. Unfortunately it is very slow. How/What can I use to send data in batches say 500 to 1000 at the time?

regards
 
Evgeniy Bulanov
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I suppose It takes ages to establish a connection to database. Try to use a connection pool in your webservices !!!
 
Jesus Angeles
Ranch Hand
Posts: 2070
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
then make you stateless ejb collect all the data and return it in one hit
 
Ulf Dittmer
Rancher
Posts: 42972
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can return arrays of any size from a web service. There's an article linked in the Web Service FAQ that shows how to do this.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!