<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<br>
I am using QGIS 2.14.3 Win64 version.<br>
I downloaded 100MB Missouri geodatabase that expanded <br>
to 168MB and worked perfectly and instantaneously.<br>
<br>
Then I downloaded 2.1GB Roads geodatabase that expanded <br>
to 3.58GB and it worked perfectly too. After turning <br>
on labels for all roads, panning over a large area required <br>
about 12 seconds to fully render the drawing. Not too <br>
bad in my opinion.<br>
<br>
Opening the attribute table took 3.6 minutes:<br>
9 million records after 1 minute<br>
14 million records after 2 minute<br>
18.5 million records after 3 minute<br>
~20 million records after 3.6 minute - fully open<br>
<br>
Doing an expression filter on the attribute table does <br>
take a very long time. More than 5 minutes. I got <br>
tired of waiting and shut it down.<br>
<br>
Am I right that the Lines geodatabase has address info <br>
for the whole country? I may get that one soon.<br>
<br>
<br>
Mike<br>
<br>
<br>
<br>
<div class="moz-cite-prefix">On 3/7/2017 2:00 PM,
<a class="moz-txt-link-abbreviated" href="mailto:qgis-user-request@lists.osgeo.org">qgis-user-request@lists.osgeo.org</a> wrote:<br>
</div>
<blockquote
cite="mid:mailman.57.1488916802.29163.qgis-user@lists.osgeo.org"
type="cite">
<pre wrap="">Date: Tue, 7 Mar 2017 14:30:13 -0500
From: "Parker, Jonathon" <a moz-do-not-send="true" class="moz-txt-link-rfc2396E" href="mailto:jparker@ispatechnology.com"><jparker@ispatechnology.com></a>
To: <a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a>
Subject: [Qgis-user] Limit to Geodatabase File Size?
Message-ID:
<a moz-do-not-send="true" class="moz-txt-link-rfc2396E" href="mailto:CA+btwMdafqR2Zuyafx=tAbB=KD1agBOXbB6u9=Ffm+BL7kB3Vw@mail.gmail.com"><CA+btwMdafqR2Zuyafx=tAbB=KD1agBOXbB6u9=Ffm+BL7kB3Vw@mail.gmail.com></a>
Content-Type: text/plain; charset="utf-8"
New user to QGIS here. Went through some tutorials, had ESRI experience in
distance past. Starting a demonstration project using data from the US
Census Bureau <a moz-do-not-send="true" class="moz-txt-link-freetext" href="https://www.census.gov/geo/maps-data/data/tiger.html">https://www.census.gov/geo/maps-data/data/tiger.html</a>
I successfully added shapefiles and small geodatabases
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="ftp://ftp2.census.gov/geo/tiger/TGRGDB16//">ftp://ftp2.census.gov/geo/tiger/TGRGDB16//</a> as layers. When I tried the
same process with a large geodatabase (tlgdb_2016_a_us_edges.gdb), it did
not render. The feature count was reported as 0. I contacted the US Census
bureau and they verified it was not corrupted and worked on ESRI products.
Is there a size limit that prevents QGIS from working with large files?
The table in the geodatabase is 13GB.</pre>
</blockquote>
<br>
</body>
</html>