<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Closing attribute table — Why do rows get selected from the database? in ArcGIS Pro Questions</title>
    <link>https://community.esri.com/t5/arcgis-pro-questions/closing-attribute-table-why-do-rows-get-selected/m-p/1287227#M68946</link>
    <description>&lt;P&gt;&lt;EM&gt;ArcGIS Pro 3.1.1; mobile geodatabase&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;I have a standalone table's &lt;U&gt;attribute table&lt;/U&gt; open.&lt;/P&gt;&lt;P&gt;When I close the attribute table:&lt;BR /&gt;In the diagnostic monitor logs, I see that the action of closing has executed a query against the database:&lt;/P&gt;&lt;PRE&gt;&amp;lt;Event time="Tue May 09 9:28:34.460" type="Debug" thread="1630: Main CIM worker thread" &lt;BR /&gt;    &lt;FONT color="#0000FF"&gt;&lt;STRONG&gt;elapsed="14674"&lt;/STRONG&gt;&lt;/FONT&gt; function="Geodatabase.Cursor" code="EndCursor"&amp;gt;
Database: C:\2023 Files\GDBs_4\New Mobile Geodatabase.geodatabase
      SQL: &lt;FONT color="#0000FF"&gt;&lt;STRONG&gt;SELECT OBJECTID FROM main.TEST_TABLE&lt;/STRONG&gt;&lt;/FONT&gt;
      Number of features returned: &lt;FONT color="#0000FF"&gt;&lt;STRONG&gt;2000&lt;/STRONG&gt;&lt;/FONT&gt;
&amp;lt;/Event&amp;gt;&lt;/PRE&gt;&lt;P&gt;That query seems unnecessary to me. Why would we want to select records when closing a table?&lt;/P&gt;&lt;P&gt;And if the table were actually a EGDB query (i.e. a database view or query layer) that was computationally intensive (slow), then that would put an unnecessary load on the enterprise database and on the network. Not to mention possibly causing performance issues in ArcGIS Pro.&lt;/P&gt;&lt;P&gt;What purpose does querying the DB on attribute table closure serve? Is that a bug?&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;Video:&lt;/P&gt;&lt;P&gt;&lt;div class="lia-vid-container video-embed-center"&gt;&lt;div id="lia-vid-6327085804112w832h540r190" class="lia-video-brightcove-player-container"&gt;&lt;video-js data-video-id="6327085804112" data-account="6161463677001" data-player="default" data-embed="default" class="vjs-fluid" controls="" data-application-id="" style="width: 100%; height: 100%;"&gt;&lt;/video-js&gt;&lt;/div&gt;&lt;script src="https://players.brightcove.net/6161463677001/default_default/index.min.js"&gt;&lt;/script&gt;&lt;script&gt;(function() {  var wrapper = document.getElementById('lia-vid-6327085804112w832h540r190');  var videoEl = wrapper ? wrapper.querySelector('video-js') : null;  if (videoEl) {     if (window.videojs) {       window.videojs(videoEl).ready(function() {         this.on('loadedmetadata', function() {           this.el().querySelectorAll('.vjs-load-progress div[data-start]').forEach(function(bar) {             bar.setAttribute('role', 'presentation');             bar.setAttribute('aria-hidden', 'true');           });         });       });     }  }})();&lt;/script&gt;&lt;a class="video-embed-link" href="https://community.esri.com/t5/video/gallerypage/video-id/6327085804112"&gt;(view in My Videos)&lt;/a&gt;&lt;/div&gt;&lt;/P&gt;</description>
    <pubDate>Tue, 09 May 2023 13:43:59 GMT</pubDate>
    <dc:creator>Bud</dc:creator>
    <dc:date>2023-05-09T13:43:59Z</dc:date>
    <item>
      <title>Closing attribute table — Why do rows get selected from the database?</title>
      <link>https://community.esri.com/t5/arcgis-pro-questions/closing-attribute-table-why-do-rows-get-selected/m-p/1287227#M68946</link>
      <description>&lt;P&gt;&lt;EM&gt;ArcGIS Pro 3.1.1; mobile geodatabase&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;I have a standalone table's &lt;U&gt;attribute table&lt;/U&gt; open.&lt;/P&gt;&lt;P&gt;When I close the attribute table:&lt;BR /&gt;In the diagnostic monitor logs, I see that the action of closing has executed a query against the database:&lt;/P&gt;&lt;PRE&gt;&amp;lt;Event time="Tue May 09 9:28:34.460" type="Debug" thread="1630: Main CIM worker thread" &lt;BR /&gt;    &lt;FONT color="#0000FF"&gt;&lt;STRONG&gt;elapsed="14674"&lt;/STRONG&gt;&lt;/FONT&gt; function="Geodatabase.Cursor" code="EndCursor"&amp;gt;
Database: C:\2023 Files\GDBs_4\New Mobile Geodatabase.geodatabase
      SQL: &lt;FONT color="#0000FF"&gt;&lt;STRONG&gt;SELECT OBJECTID FROM main.TEST_TABLE&lt;/STRONG&gt;&lt;/FONT&gt;
      Number of features returned: &lt;FONT color="#0000FF"&gt;&lt;STRONG&gt;2000&lt;/STRONG&gt;&lt;/FONT&gt;
&amp;lt;/Event&amp;gt;&lt;/PRE&gt;&lt;P&gt;That query seems unnecessary to me. Why would we want to select records when closing a table?&lt;/P&gt;&lt;P&gt;And if the table were actually a EGDB query (i.e. a database view or query layer) that was computationally intensive (slow), then that would put an unnecessary load on the enterprise database and on the network. Not to mention possibly causing performance issues in ArcGIS Pro.&lt;/P&gt;&lt;P&gt;What purpose does querying the DB on attribute table closure serve? Is that a bug?&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;Video:&lt;/P&gt;&lt;P&gt;&lt;div class="lia-vid-container video-embed-center"&gt;&lt;div id="lia-vid-6327085804112w832h540r318" class="lia-video-brightcove-player-container"&gt;&lt;video-js data-video-id="6327085804112" data-account="6161463677001" data-player="default" data-embed="default" class="vjs-fluid" controls="" data-application-id="" style="width: 100%; height: 100%;"&gt;&lt;/video-js&gt;&lt;/div&gt;&lt;script src="https://players.brightcove.net/6161463677001/default_default/index.min.js"&gt;&lt;/script&gt;&lt;script&gt;(function() {  var wrapper = document.getElementById('lia-vid-6327085804112w832h540r318');  var videoEl = wrapper ? wrapper.querySelector('video-js') : null;  if (videoEl) {     if (window.videojs) {       window.videojs(videoEl).ready(function() {         this.on('loadedmetadata', function() {           this.el().querySelectorAll('.vjs-load-progress div[data-start]').forEach(function(bar) {             bar.setAttribute('role', 'presentation');             bar.setAttribute('aria-hidden', 'true');           });         });       });     }  }})();&lt;/script&gt;&lt;a class="video-embed-link" href="https://community.esri.com/t5/video/gallerypage/video-id/6327085804112"&gt;(view in My Videos)&lt;/a&gt;&lt;/div&gt;&lt;/P&gt;</description>
      <pubDate>Tue, 09 May 2023 13:43:59 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-pro-questions/closing-attribute-table-why-do-rows-get-selected/m-p/1287227#M68946</guid>
      <dc:creator>Bud</dc:creator>
      <dc:date>2023-05-09T13:43:59Z</dc:date>
    </item>
  </channel>
</rss>

