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

楼主^#

更多发布于：2009-06-23 15:13

一、 几种删除方法代码
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、 测试情况

<table border="1" cellpadding="0" cellspacing="0">

 <tr >
 <td valign="top" width="175">
 测试方法
 </td>
 <td valign="top" width="191">
 第一次时间（单位ms）
 </td>
 <td valign="top" width="169">
 第一次时间（单位ms）
 </td>
 </tr>
 <tr >
 <td valign="top" width="175">
 1
 </td>
 <td valign="top" width="191">
 5214ms
 </td>
 <td valign="top" width="169">
 5735ms
 </td>
 </tr>
 <tr >
 <td valign="top" width="175">
 2
 </td>
 <td valign="top" width="191">
 299ms
 </td>
 <td valign="top" width="169">
 290Ms
 </td>
 </tr>
 <tr >
 <td valign="top" width="175">
 3
 </td>
 <td valign="top" width="191">
 59ms
 </td>
 <td valign="top" width="169">
 28ms
 </td>
 </tr>
 <tr >
 <td valign="top" width="175">
 4
 </td>
 <td valign="top" width="191">
 26ms
 </td>
 <td valign="top" width="169">
 26ms
 </td>
 </tr>
 </table>

 三、 结论
 1、 使用ExecuteSQL删除最快，数据库的效率最高。
 2、 DeleteSearchedRows和ExecuteSQL属于批量删除，性能较优。
 3、 查询结果中删除，速度最慢，如果你使用这种方法，建立你马上修改你的程序，因为你在浪费时间。

喜欢0 评分0

没钱又丑，农村户口。头可断，发型一定不能乱。邮箱:gisempire@qq.com

举报回复

yanleigis 路人甲注册日期2003-12-13 发帖数38 QQ 铜币185枚威望0点贡献值0点银元0个加关注写私信	1楼^# 发布于：2009-06-30 08:54 我写的，转载怎么没有我的信息
	举报回复(0) 喜欢(0) 评分

您需要登录后才可以回帖，登录或者注册

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

最新喜欢：