<div dir="ltr">You could export the shapefile and use <i>Layer Options > RESIZE=YES</i>. This is the same as the ogr2ogr switch <i>-lco RESIZE=YES</i>, which reduces the attribute column widths down to their minimum width required to store the longest actual value in the data. A dbf file allocates space for the full column width even if it's empty. So for example if you have a column width of 254 characters but the longest string is only 12 characters, your dbf will have a lot of wasted space in it. Resizing the column would write out a new dbf with a column width of 12 characters.</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jul 28, 2022 at 8:15 AM jhubbslist--- via Qgis-user <<a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</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>
<div>Past a point, trying to run a GIS app
with very large data structures just doesn't work well. If you
really need all the information you're carrying around for your
analysis or whatever, you may need to reach for different tools or
use the tools you have differently. <br>
</div>
<div><br>
</div>
<div>I assume it's not so much the >5GiB
of disk space that's the issue and that you've maxxed out the CPU,
graphics, and disk I/O rate as much as is practical so mostly it's
a matter of how long it takes maps etc. to paint onscreen. It may
help you to move the heavy-lift onto PostgreSQL/PostGIS where you
can make use of spatial indexing. Or, you can craft your
operations the way you want them in QGIS but do the actual work
with e.g. GDAL calls in Python. I spoke with someone a couple
weeks ago whose particular GIS process worked better in GRASS than
in QGIS, so that's something you might look into as well.<br>
</div>
<div><br>
</div>
<div>On 7/28/22 7:52 AM, krishna Ayyala via
Qgis-user wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">dbf file itself is 5.1GB. Rest all other files are
less than 500MB. It is the number of records which is huge. It
has about 117,2100 points.</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Thu, Jul 28, 2022 at 12:02
AM Bernd Vogelgesang via Qgis-user <<a href="mailto:qgis-user@lists.osgeo.org" target="_blank">qgis-user@lists.osgeo.org</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote">how big is the dbf file of that
shape? Maybe you can also drop some<br>
attributes.<br>
<br>
Am 28.07.22 um 03:46 schrieb krishna Ayyala via Qgis-user:<br>
> Hello,<br>
> I have a shapefile of 5GB in size. Is it possible to
convert this<br>
> shapefile to a smaller size file? It can be any format,
not<br>
> necessarily a shapefile. But, preferably a vector format.
I tried to<br>
> convert it into tiles, but that didn't work as it was
losing the<br>
> resolution. I am looking to convert this 5GB size file to
about 500MB.<br>
><br>
> Regards.<br>
><br>
> _______________________________________________<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><br>
_______________________________________________<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><br>
</blockquote>
</div>
<br>
<fieldset></fieldset>
<pre>_______________________________________________
Qgis-user mailing list
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
</pre>
</blockquote>
<p><br>
</p>
</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><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr">Richard W. Greenwood<br><a href="http://www.greenwoodmap.com" target="_blank">www.greenwoodmap.com</a></div></div>