Hi,
Glad to hear that it helped to run the operations on a closed table.
Nevertheless, as Luigi said, it would make sense to submit an issue
report about this slowness.
The other thing one has to keep on mind:
The SQLite API is kind of limited. Only until recently, if you wanted to
rename a field, one had to copy the whole table with the renamed field
changed in the new table - then the old table had to be removed (all in
the background), because there was API to rename columns in SQLite. I
think with the very recent version, which is not rolled out into most
OS, this has changed. You'd also need a very recent GDAL/OGR.
Greetings,
Andreas
Am 03.10.2018 um 21:20 schrieb 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 <lui...@gmail.com
<mailto: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
<mailto: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 <mailto:kj...@indeed.com>
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org <mailto: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 <mailto: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
_______________________________________________
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
