ArcEngine数据删除几种方法和性能比较

最新推荐文章于 2019-08-02 13:46:00 发布

YoungHappyGIS

最新推荐文章于 2019-08-02 13:46:00 发布

阅读量742

点赞数 1

分类专栏： ArcEngine 文章标签： ArcEngine 删除要素

ArcEngine 专栏收录该内容

54 篇文章

订阅专栏

本文详细介绍了在特定场景下使用不同方法进行数据删除的操作，包括查询结果中删除、更新游标删除、使用DeleteSearchedRows删除及ExecuteSQL删除，并通过性能测试对比了这些方法的效率。结果显示，ExecuteSQL方法最快，适用于大量数据删除。

转载连接：http://www.cnblogs.com/willwayer/archive/2011/04/29/2032491.html

1、IFeatureCursor 游标查询后，遍历删除

2、更新游标删除IFeatureCursor.DeleteFeature()

3、ITable.DeleteSearchedRows删除

4、 IDataset.Workspace.ExecuteSQL

一、几种删除方法代码

1. 查询结果中删除

  
    
   private
    
   void
    Delete1(IFeatureClass PFeatureclass)
 {
  IQueryFilter pQueryFilter 
   =
    
   new
    QueryFilterClass();
  pQueryFilter.WhereClause 
   =
    
   "
   objectID<=
   "
    
   +
    DeleteNum;
  IFeatureCursor pFeatureCursor 
   =
    PFeatureclass.Search(pQueryFilter, 
   false
   );            
  
  
     IFeature pFeature 
   =
    pFeatureCursor.NextFeature();
  
   while
    (pFeature 
   !=
    
   null
   )
  {
    pFeature.Delete();
    pFeature 
   =
    pFeatureCursor.NextFeature();
  }
  System.Runtime.InteropServices.Marshal.ReleaseComObject(pQueryFilter);
 }

2. 更新游标删除

 
         private 
         void 
         Delete2(IFeatureClass PFeatureclass)
        
         {
        
         IQueryFilter pQueryFilter = 
         new 
         QueryFilterClass();
        
         pQueryFilter.WhereClause = 
         "objectID<=" 
         + DeleteNum;
        
         IFeatureCursor pFeatureCursor = PFeatureclass.Update(pQueryFilter, 
         false
         );
        
         IFeature pFeature = pFeatureCursor.NextFeature();
        
         while 
         (pFeature != 
         null
         )
        
         {
        
         pFeatureCursor.DeleteFeature();
        
         pFeature = pFeatureCursor.NextFeature();
        
         }
        
         System.Runtime.InteropServices.Marshal.ReleaseComObject(pQueryFilter);
        
         }

3.  使用DeleteSearchedRows删除
private void Delete4(IFeatureClass PFeatureclass)
        {
            IQueryFilter pQueryFilter = new QueryFilterClass();
            pQueryFilter.WhereClause = "objectID<=" + DeleteNum;
            ITable pTable = PFeatureclass as ITable;
            pTable.DeleteSearchedRows(pQueryFilter);
            System.Runtime.InteropServices.Marshal.ReleaseComObject(pQueryFilter);
        }

4.  ExecuteSQL删除
private void Delete4(IFeatureClass PFeatureclass)
        {
            IDataset pDataset = PFeatureclass as IDataset;
            pDataset.Workspace.ExecuteSQL("delete from " + PFeatureclass.AliasName + " where objectid<=" + DeleteNum);
        }

二、  测试性能和比较
1、       相同的数据条件，删除2000条记录

2、       测试代码

IFeatureLayer pFeatureLayer = axMapControl1.Map.get_Layer(0) as IFeatureLayer;
            IFeatureClass PFeatureClass = pFeatureLayer.FeatureClass;
            System.Diagnostics.Stopwatch MyWatch = new System.Diagnostics.Stopwatch();
            MyWatch.Start();
            Delete1(PFeatureClass)
            //Delete2(PFeatureClass);
            //Delete3(PFeatureClass);
            //Delete4(PFeatureClass);
            //Delete5(PFeatureClass);
            MyWatch.Stop();
            MessageBox.Show("删除时间:" + MyWatch.ElapsedMilliseconds.ToString() + "毫秒");
3、       测试情况
测试方法
第一次时间（单位ms）
第一次时间（单位ms）
1
5214ms
5735ms

2
299ms
290Ms

3
59ms
28ms

4
26ms
26ms

三、  结论