Re: [QGIS-Developer] Whatever is wrong with QGIS 3.x SQL server driver

Thanks Nyall - "I'll be back !" - in about a week or so Den fre. 7. dec. 2018 kl. 00.09 skrev Nyall Dawson : > On Fri, 7 Dec 2018 at 00:13, Bo Victor Thomsen > wrote: > > > There is not much difference in the SQL Server execution times for the 3 > queries (around 200 - 300 ms) , so that can't

Re: [QGIS-Developer] [Ubuntu] Bionic updates

Hi Jurgen, New packages have just landed on UbuntuGIS Unstable ppa. Can you please rebuild your QGIS 3.4.x package that depends on that ppa? Thanks! Angelos On 11/19/18 5:08 PM, Angelos Tzotsos wrote: Hi all, I have pushed some updates to experimental ppa for testing. The changes include: *

Re: [QGIS-Developer] Whatever is wrong with QGIS 3.x SQL server driver

On Fri, 7 Dec 2018 at 00:13, Bo Victor Thomsen wrote: > There is not much difference in the SQL Server execution times for the 3 > queries (around 200 - 300 ms) , so that can't explain the time difference in > QGIS > > QGIS 2 with native driver and QGIS 3 with ogr driver uses appr. the same

[QGIS-Developer] Plugin [1412] GeoDataFarm approval notification.

Plugin GeoDataFarm approval by pcav. The plugin version "[1412] GeoDataFarm 2.0.4" is now approved Link: http://plugins.qgis.org/plugins/geodatafarm/ ___ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info:

Re: [QGIS-Developer] [Qgis-user] Question About QgsGeometry Static Functions

Thanks Nyall. I think I had a misunderstanding in that the XY routines were the preferred method to use unless you have Z/M dimensions. I will look at changing my code. Calvin On Wed, Dec 5, 2018 at 6:06 PM Nyall Dawson wrote: > On Wed, 5 Dec 2018 at 02:52, C Hamilton wrote: > > > >

Re: [QGIS-Developer] Whatever is wrong with QGIS 3.x SQL server driver

Hi Nyall - Back again .. The 3 different sql queries from QGIS. -- QGIS 3, native driver SELECT [cell100_key],[geom_flade] FROM [dbo].[cells3] WHERE [geom_flade].STIsValid() = 1 AND [geom_flade].Filter([geometry]::STGeomFromText('POLYGON((823546.46544876880943775 610,

[QGIS-Developer] Plugin [971] Disconnected Islands approval notification.

Plugin Disconnected Islands approval by pcav. The plugin version "[971] Disconnected Islands 2.0.1" is now approved Link: http://plugins.qgis.org/plugins/disconnected-islands/ ___ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info:

Re: [QGIS-Developer] Whatever is wrong with QGIS 3.x SQL server driver

Ok, I'll take a look and monitor the queries from QGIS 2 and 3 and report back. It will take a couple of days And thanks Nyall Den tor. 6. dec. 2018 kl. 11.54 skrev Nyall Dawson : > On Thu, 6 Dec 2018 at 20:34, Bo Victor Thomsen > wrote: > > > > Hi Nyall - > > > > I'm running QGIS 3.4.2 on

Re: [QGIS-Developer] Whatever is wrong with QGIS 3.x SQL server driver

On Thu, 6 Dec 2018 at 20:34, Bo Victor Thomsen wrote: > > Hi Nyall - > > I'm running QGIS 3.4.2 on Windows ver.10. > > > > Have there been any other changes to the SQLServer driver besides the > validity check? (I remember vaguely something about the internal > representation of spatial objects

Re: [QGIS-Developer] Whatever is wrong with QGIS 3.x SQL server driver

Hi Nyall - I'm running QGIS 3.4.2 on Windows ver.10. Have there been any other changes to the SQLServer driver besides the validity check? (I remember vaguely something about the internal representation of spatial objects in the driver) I'm asking, because I've done this type of testing QGIS

Re: [QGIS-Developer] Whatever is wrong with QGIS 3.x SQL server driver

On Thu, 6 Dec 2018 at 20:05, Bo Victor Thomsen wrote: > I've tried switching the validity check off as described. As far as I can > measure, there is no time difference with or without the validity check. When > does the validity check kick in? Writing or reading the features? Or both? > It's

Re: [QGIS-Developer] Whatever is wrong with QGIS 3.x SQL server driver

Hi Nyall - Thanks for taking your time answering me :-) I've tried switching the validity check off as described. As far as I can measure, there is no time difference with or without the validity check. When does the validity check kick in? Writing or reading the features? Or both? And

Re: [QGIS-Developer] Whatever is wrong with QGIS 3.x SQL server driver

On Thu, 6 Dec 2018 at 19:05, Bo Victor Thomsen wrote: > > Hi list - > > > > I've done some experiments with a dataset consisting of 44 rows and > uploaded this to two database servers: Postgres and SQLServer. Both tables > has indexes on Primary key and the spatial column. > > > > And then

[QGIS-Developer] Whatever is wrong with QGIS 3.x SQL server driver

Hi list - I've done some experiments with a dataset consisting of 44 rows and uploaded this to two database servers: Postgres and SQLServer. Both tables has indexes on Primary key and the spatial column. And then connected to both tables in QGIS. The SQL server is *3 times* slower in

[QGIS-Developer] Plugin [412] Qgis2threejs approval notification.

Plugin Qgis2threejs approval by pcav. The plugin version "[412] Qgis2threejs 2.3" is now approved Link: http://plugins.qgis.org/plugins/Qgis2threejs/ ___ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info:

[QGIS-Developer] Plugin [1357] Least-Cost-Paths Network approval notification.

Plugin Least-Cost-Paths Network approval by pcav. The plugin version "[1357] Least-Cost-Paths Network 0.1.3 Experimental" is now approved Link: http://plugins.qgis.org/plugins/LCPNetwork/ ___ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org