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

[Luigi Pirelli]

may you open an issue about this slowness with all details to reproduce?
Only with opened issue the project can allocate resources to fix them...
and we are just in bugfix period before the 3.4 release. So your
contribution would be precious.

tnx

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 21:20, Kelley Jabr <kjabr at indeed.com> wrote:

> 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/ff9a6142/attachment.html>