topic Re: Bulk insert in versioned table view taking long time to run in Data Management Questions https://community.esri.com/t5/data-management-questions/bulk-insert-in-versioned-table-view-taking-long/m-p/452437#M25833 <HTML><HEAD></HEAD><BODY><SPAN>"Bulk insert" and "versioned table view" are inherently incompatible.</SPAN><BR /><SPAN>Please explain exactly what you are trying to accomplish and exactly</SPAN><BR /><SPAN>how you are trying to accomplish it.</SPAN><BR /><BR /><SPAN>- V</SPAN></BODY></HTML> Wed, 18 Jun 2014 11:48:38 GMT VinceAngelo 2014-06-18T11:48:38Z Bulk insert in versioned table view taking long time to run https://community.esri.com/t5/data-management-questions/bulk-insert-in-versioned-table-view-taking-long/m-p/452435#M25831 <HTML><HEAD></HEAD><BODY><SPAN>Dear All,</SPAN><BR /><BR /><SPAN>I am having a version ArcSDE(10.1) Object Class in SQL Server 2008 R2 production database.</SPAN><BR /><SPAN>I am trying for bulk insert in version table view using SQL in back-end. It's taking too much </SPAN><BR /><BR /><SPAN>time to insert 4 lacs records.</SPAN><BR /><BR /><SPAN>Please suggest / share valuable inputs &amp; experience from possibilities and especially </SPAN><BR /><BR /><SPAN>performance point of view. </SPAN><BR /><BR /><SPAN>Your earliest response is highly appreciated</SPAN><BR /><BR /><SPAN>Regards,</SPAN><BR /><SPAN>Ashish</SPAN></BODY></HTML> Wed, 18 Jun 2014 06:27:56 GMT https://community.esri.com/t5/data-management-questions/bulk-insert-in-versioned-table-view-taking-long/m-p/452435#M25831 Ashish_KumarGupta 2014-06-18T06:27:56Z Re: Bulk insert in versioned table view taking long time to run https://community.esri.com/t5/data-management-questions/bulk-insert-in-versioned-table-view-taking-long/m-p/452436#M25832 <HTML><HEAD></HEAD><BODY><SPAN>First, make sure that your geodatabase is tuned (perform reconcile/post/compress operations)</SPAN><BR /><BR /><SPAN>then try again. and check if there is performance enhancement.</SPAN><BR /><BR /><SPAN>Regards,</SPAN></BODY></HTML> Wed, 18 Jun 2014 08:40:19 GMT https://community.esri.com/t5/data-management-questions/bulk-insert-in-versioned-table-view-taking-long/m-p/452436#M25832 EmadAl-Mousa 2014-06-18T08:40:19Z Re: Bulk insert in versioned table view taking long time to run https://community.esri.com/t5/data-management-questions/bulk-insert-in-versioned-table-view-taking-long/m-p/452437#M25833 <HTML><HEAD></HEAD><BODY><SPAN>"Bulk insert" and "versioned table view" are inherently incompatible.</SPAN><BR /><SPAN>Please explain exactly what you are trying to accomplish and exactly</SPAN><BR /><SPAN>how you are trying to accomplish it.</SPAN><BR /><BR /><SPAN>- V</SPAN></BODY></HTML> Wed, 18 Jun 2014 11:48:38 GMT https://community.esri.com/t5/data-management-questions/bulk-insert-in-versioned-table-view-taking-long/m-p/452437#M25833 VinceAngelo 2014-06-18T11:48:38Z