DevForce Community Forum : Question on saving records http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Question on saving records Tue, 12 May 2026 21:28:03 -700 Mon, 02 Dec 2013 11:24:38 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=4618 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Question on saving records : If you need everything in a single... http://www.ideablade.com/forum/forum_posts.asp?TID=4618&PID=17278#17278 Author: kimj
Subject: 4618
Posted: 02-Dec-2013 at 11:24am

If you need everything in a single transaction, then you'll have to save all changes at one time.  I assume you're worried about performance when saving several thousand entities at once - it should be doable, although you might need to modify some timeouts. 
 
Saving individually would work too.  DF2010 supports partial save, so that's one option.  Another is to use a separate EM for each save.
]]> Mon, 02 Dec 2013 11:24:38 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4618&PID=17278#17278 Question on saving records : I have a coroutine where one of... http://www.ideablade.com/forum/forum_posts.asp?TID=4618&PID=17276#17276 Author: BillG
Subject: 4618
Posted: 02-Dec-2013 at 10:58am

I have a coroutine where one of the parts of it loops through a collection and for each record in the collection (ex. member) creates a new entity of type (payment). There could be anywhere from several hundred to several thousand records that have to be created. As each payment row is created should I save it one at a time to the database or add it to the current entity manager cache and save the whole cache at once?
]]> Mon, 02 Dec 2013 10:58:29 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4618&PID=17276#17276