[Qgis-user] Very Slow Table Operations in QGIS 3.2.3

Luigi Pirelli luipir at gmail.com
Wed Oct 3 11:43:37 PDT 2018


can you test doing operations with field calculator without having the
attribute table opened? just a workaround could be to use a virtual layer
then save the entire layer later.

Luigi Pirelli

**************************************************************************************************
* LinkedIn: https://www.linkedin.com/in/luigipirelli
* Stackexchange: http://gis.stackexchange.com/users/19667/luigi-pirelli
* GitHub: https://github.com/luipir
* Mastering QGIS 2nd Edition:
*
https://www.packtpub.com/big-data-and-business-intelligence/mastering-qgis-second-edition
* Hire me: http://goo.gl/BYRQKg
**************************************************************************************************


On Wed, 3 Oct 2018 at 18:11, Kelley Jabr <kjabr at indeed.com> wrote:

> Hello,
>
> I'm working with a geopackage on ~530k features, and just about everything
> I try to do in the table takes way longer than expected.
>
>    - Adding a field took 5 minutes (table now has 22 total fields, so not
>    massive)
>    - Field Calculator on ~32k selected records took 8 minutes (literally
>    all I was putting in the cells was: N)
>    - Field calculator on ~480k records took so many hours that I had to
>    leave it running over the weekend and when I came back, the Field
>    Calculator had "closed unexpectedly"
>
> (I'm running on a linux machine with an Intel Core i7 and 32GB of memory.)
>
> Has anyone else experience similar issues? Any advice or recommendations
> for how to improve performance here?
>
> Thank you,
>
> --
>
> Kelley Jabr
>
> Analyst, Geographic Data Operations
>
> kjabr at indeed.com
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20181003/a08c477d/attachment.html>


More information about the Qgis-user mailing list