• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

batch updating mysql

 
mat buckland
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a Container of objects in my server, which regularly need writing to the database. At the moment I simply iterate through the container and do an executeUpdate() for each object.

This is slow though. Is there a way I can create an update that will send all the objects to the database in one cumulative update instead of many?

thanks
 
mat buckland
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
tis ok, i've found the answer!
 
Campbell Ritchie
Sheriff
Pie
Posts: 49793
69
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well done

For the benefit of future generations searching this forum, how did you do it?
 
mat buckland
Greenhorn
Posts: 24
 
Campbell Ritchie
Sheriff
Pie
Posts: 49793
69
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It's nice when you can find links like that, isn't it
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic