topic Re: 10.1 beta and comtypes in Python Questions https://community.esri.com/t5/python-questions/10-1-beta-and-comtypes/m-p/382046#M30105 <HTML><HEAD></HEAD><BODY><SPAN>Thanks for sharing, this is encouraging.</SPAN></BODY></HTML> Fri, 11 Nov 2011 15:51:10 GMT JasonScheirer 2011-11-11T15:51:10Z 10.1 beta and comtypes https://community.esri.com/t5/python-questions/10-1-beta-and-comtypes/m-p/382043#M30102 <HTML><HEAD></HEAD><BODY><SPAN>I've been really busy this year and only just now started looking at the 10.1 beta.&nbsp; I noticed that the current version of comtypes croaks when trying to wrap esriSystem.olb.&nbsp; Fortunately, you can remedy this by adding the following entry to the _ctype_to_vartype dictionary in automation.py:</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp; POINTER(BSTR): VT_BYREF|VT_BSTR,</SPAN><BR /><BR /><SPAN>If there's a better approach I'd like to hear about it.</SPAN><BR /><BR /><BR /><SPAN>Also note that arcpy.da approaches ArcObjects via comtypes in terms of performance.&nbsp; To query and hydrate ~500,000 polygons from a file GDB feature class:</SPAN><BR /><BR /><SPAN>ArcGIS 10.0SP3:</SPAN><BR /><SPAN>---------------</SPAN><BR /><SPAN>ArcObjects/comtypes: 31 sec</SPAN><BR /><SPAN>arcpy.SearchCursor: 96 sec</SPAN><BR /><BR /><SPAN>ArcGIS 10.1 Beta:</SPAN><BR /><SPAN>-----------------</SPAN><BR /><SPAN>ArcObjects/comtypes: 21 sec</SPAN><BR /><SPAN>arcpy.SearchCursor: 85 sec</SPAN><BR /><SPAN>arcpy.da.SearchCursor: 27 sec</SPAN></BODY></HTML> Thu, 10 Nov 2011 17:39:07 GMT https://community.esri.com/t5/python-questions/10-1-beta-and-comtypes/m-p/382043#M30102 MarkCederholm 2011-11-10T17:39:07Z Re: 10.1 beta and comtypes https://community.esri.com/t5/python-questions/10-1-beta-and-comtypes/m-p/382044#M30103 <HTML><HEAD></HEAD><BODY><SPAN>Nice. Could you share your code? Have you tried benchmarking against a cursor without a shape field or using one of the Shape@XY etc shortcuts?</SPAN></BODY></HTML> Thu, 10 Nov 2011 21:56:42 GMT https://community.esri.com/t5/python-questions/10-1-beta-and-comtypes/m-p/382044#M30103 JasonScheirer 2011-11-10T21:56:42Z Re: 10.1 beta and comtypes https://community.esri.com/t5/python-questions/10-1-beta-and-comtypes/m-p/382045#M30104 <HTML><HEAD></HEAD><BODY><SPAN>arcpy.da blows away ArcObjects for accessing table fields in a file gdb:</SPAN><BR /><BR /><SPAN>ArcObjects/comtypes (Shape_Area): 13 sec</SPAN><BR /><SPAN>arcpy.SearchCursor (Shape_Area): 65 sec</SPAN><BR /><SPAN>arcpy.da.SearchCursor (Shape_Area): 2 sec</SPAN><BR /><SPAN>arcpy.da.SearchCursor (SHAPE@AREA): 14 sec</SPAN></BODY></HTML> Fri, 11 Nov 2011 13:37:02 GMT https://community.esri.com/t5/python-questions/10-1-beta-and-comtypes/m-p/382045#M30104 MarkCederholm 2011-11-11T13:37:02Z Re: 10.1 beta and comtypes https://community.esri.com/t5/python-questions/10-1-beta-and-comtypes/m-p/382046#M30105 <HTML><HEAD></HEAD><BODY><SPAN>Thanks for sharing, this is encouraging.</SPAN></BODY></HTML> Fri, 11 Nov 2011 15:51:10 GMT https://community.esri.com/t5/python-questions/10-1-beta-and-comtypes/m-p/382046#M30105 JasonScheirer 2011-11-11T15:51:10Z Re: 10.1 beta and comtypes https://community.esri.com/t5/python-questions/10-1-beta-and-comtypes/m-p/382047#M30106 <HTML><HEAD></HEAD><BODY><SPAN>Just curious, but is the da module using numpy recarrays? or is it some com wrapper thing?</SPAN></BODY></HTML> Fri, 11 Nov 2011 17:31:59 GMT https://community.esri.com/t5/python-questions/10-1-beta-and-comtypes/m-p/382047#M30106 DanPatterson_Retired 2011-11-11T17:31:59Z Re: 10.1 beta and comtypes https://community.esri.com/t5/python-questions/10-1-beta-and-comtypes/m-p/382048#M30107 <HTML><HEAD></HEAD><BODY><SPAN>A little of column a, a little of column b.</SPAN></BODY></HTML> Fri, 11 Nov 2011 19:26:19 GMT https://community.esri.com/t5/python-questions/10-1-beta-and-comtypes/m-p/382048#M30107 JasonScheirer 2011-11-11T19:26:19Z Re: 10.1 beta and comtypes https://community.esri.com/t5/python-questions/10-1-beta-and-comtypes/m-p/382049#M30108 <HTML><HEAD></HEAD><BODY><SPAN>Jason ... oh you all revealing types <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></SPAN><BR /><SPAN>Thanks</SPAN></BODY></HTML> Fri, 11 Nov 2011 20:01:31 GMT https://community.esri.com/t5/python-questions/10-1-beta-and-comtypes/m-p/382049#M30108 DanPatterson_Retired 2011-11-11T20:01:31Z