Re:QGIS is the mapping software you didn't know you needed
by maptime on Saturday February 11, 2023 @06:04PM
(#34757349)
Glad it worked!
It should only do it once per table but if you are dropping and creating tables often it will be making the DB have a heavy workload
I think theirs an assumption within the geo community of read heavy workloads but I could be wrong
Re:QGIS is the mapping software you didn't know you needed
by sohnakukkar on Monday February 13, 2023 @10:33AM
(#34774691)
Could you provide more info about your hardware setup and data size? Why do you need hundreds of layers? Which domain you are working on?
That fixed it, thanks! Looking at the manual, there is a tip that tells you to turn that on, otherwise it will read the entire table to characterize the geometries... It's a bit mad that the default behavior has it querying potentially gigabytes of information across the network every time you open the app and click a dropdown, with no progress bar. But it's definitely the type of app where you need to read the manual, and it says so right there.