Latest Contributions by DaleBrooks

These are my VS Code settings I used (with cmd.exe as the default shell):   "python.condaPath": "C:\\Users\\<myusername>\\Miniconda3\\Scripts\\conda.exe",   "python.defaultInterpreterPath": "C:\\Program Files\\ArcGIS\\Pro\\bin\\Python\\envs\\<my cloned py3 dir>\\python.exe",   "terminal.integrated.defaultProfile.windows": "Command Prompt",   "terminal.integrated.profiles.windows": {     "Command Prompt": {       "path": [         "${env:windir}\\Sysnative\\cmd.exe",         "${env:windir}\\System32\\cmd.exe"       ],       "args": [""],       "icon": "terminal-cmd"     }   } ... View more

I am a big believer in use of stored procedures for their full capabilities, especially since the spatial columns in most common DBMS's have a SQL API to go with them (several are Esri ST_Geometry or Esri/DBMS Vendor implementations).  You can white holistic PL/SQL on spatial and non-spatial data tables (minding, of course, the documentation of the specific conditions under which SQL based programming is safe and supported).  See links below. Very important regarding Stored Procedure development: Should be done only after fully reviewing and understanding Esri's documentation on SQL access to the database.  Start here:      SQL and enterprise geodatabases—Help | ArcGIS Desktop        (Also look in Esri's Proceedings for "SQL".  Watch for 2018 International and DC Developer Summit Proceedings, coming soon)  Recent Proceedings  Should be done by a highly experienced Esri geodatabase and DBMS developer ... View more

Consider: How to handle Oracle BLOB columns via Database Link  as an example of ways that developers have been solving this problem. Also, don't forget WKB for a smaller payload than WKT. Also, Ask Tom mentions 12.2 and the lifting of some restrictions regarding LOBs: Ask TOM "Transfer data from one db to another db over db li..."  -Dale ... View more

Capturing display times is an important part of your analysis, but can't tell you just what the performance difference is based on. Unpacking time, as you refer to, is one possibility, but there are many others. Have you done Oracle traces and PL/SQL profiles in the database while performing the draws?  Recommend separating db time from network time from client time, at a minimum. Dale ... View more