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 <lui...@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 <kj...@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 >> >> kj...@indeed.com >> >> _______________________________________________ >> Qgis-user mailing list >> Qgis-user@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 kj...@indeed.com Indeed - We help people get jobs. Indeed.com <http://www.indeed.com>
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user