<div dir="ltr"><div dir="ltr">Hi William, fellow BC'er here.<div><br></div><div>One thing you can do is change the default behaviour, like instead of loading all features, try loading only features visible on map (or selected features).</div><div><br></div><div>Can change that in Settings > Options then the Data Source tab. You'll see an "attribute table behavior" pull down menu with some self-explanatory options.</div><div><br></div><div>Some hotkeys that also work, without changing the default attribute table behaviour are:</div><div><br></div><div>F6 - open attribute table</div><div>Shift + F6 - open attribute table showing only selected features</div><div>CTRL + F6 - open attribute table showing only visible features on canvas</div><div><br></div><div>Happy QGIS'ing!</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Jun 12, 2019 at 6:50 PM Patrick Dunford <<a href="mailto:enzedrailmaps@gmail.com">enzedrailmaps@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div bgcolor="#FFFFFF">
<p>Is the attribute table failing to load or simply taking a very
long time to load?</p>
<p>I use some old shapefiles with around 500,000 rows, they are very
slow loading, it just takes a time, I think is probably the same
for a lot of large datasets, but it doesn't have trouble drawing
the layers on the canvas<br>
</p>
<div class="gmail-m_8212561013295606111moz-cite-prefix">On 13/06/19 11:28 AM, Burt, William
FLNR:EX wrote:<br>
</div>
<blockquote type="cite">
<div class="gmail-m_8212561013295606111WordSection1">
<p class="MsoNormal">Hi users. <u></u><u></u></p>
<p class="MsoNormal">I am looking for some best practice tips
for working with datasets with many rows. Using QGIS 3.4.4
Our organization regularly works with large oracle database
tables covering a large geographic region(eg 2 M+ rows, 1 +
Gb). QGIS seems to draw these layers fine but chokes on them
when opening the attribute table. Is there a way to limit
fetched rows or other best practices in cases like this?<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Thanks for your time,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Will<u></u><u></u></p>
</div>
<br>
<fieldset class="gmail-m_8212561013295606111mimeAttachmentHeader"></fieldset>
<pre class="gmail-m_8212561013295606111moz-quote-pre">_______________________________________________
Qgis-user mailing list
<a class="gmail-m_8212561013295606111moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a>
List info: <a class="gmail-m_8212561013295606111moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="gmail-m_8212561013295606111moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
</div>
_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></blockquote></div></div><div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br>
<table style="border-top:1px solid #d3d4de">
<tr>
<td style="width:55px;padding-top:13px"><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif" alt="" width="46" height="29" style="width: 46px; height: 29px;"></a></td>
<td style="width:470px;padding-top:12px;color:#41424e;font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">Virus-free. <a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank" style="color:#4453ea">www.avast.com</a>
</td>
</tr>
</table><a href="#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"></a></div>