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

[Kelley Jabr]

Luigi, I'm pretty sure you just solved my problem. I tried a few operations
with the table closed and it was like night and day. That 400k field
calculator finished in mere moments! Thank you!!

On Wed, Oct 3, 2018 at 1:42 PM Luigi Pirelli <luipir at gmail.com> wrote:

> 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
>
>

-- 

Kelley Jabr

Analyst, Geographic Data Operations

kjabr at indeed.com

Indeed - We help people get jobs.

Indeed.com <http://www.indeed.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20181003/3c521e4d/attachment.html>