Re: [Qgis-developer] SpatiaLite very slow with QGIS 1.7

2011-03-21 Thread a . furieri
On Sun, 20 Mar 2011 23:58:13 +0100, Jürgen E. Fischer wrote Fixed in r15545. Hi Jef, I can confirm: my own test suite runs absolutely smooth and fast on r15546. bye Sandro ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org

Re: [Qgis-developer] SpatiaLite very slow with QGIS 1.7

2011-03-20 Thread a . furieri
On Thu, 17 Mar 2011 17:08:43 -0500, Cline, Royce L. wrote Did further testing. The problem is a power function of the number of layers. QGIS 1.7 r15529M. # layersload time quit time 402.3s1.6s 603.6s3.4 s 68

Re: [Qgis-developer] SpatiaLite very slow with QGIS 1.7

2011-03-20 Thread Giovanni Manghi
Hi, while debugging the above issue noticed by Royce, I casually discovered a major issue affecting any recent (1.7.0) QGIS version. can this be the reason why the user find qgis trunk generally slower than 1.6? cheers -- Giovanni -- ___

Re: [Qgis-developer] SpatiaLite very slow with QGIS 1.7

2011-03-20 Thread Martin Dobias
On Sun, Mar 20, 2011 at 11:09 AM, a.furi...@lqt.it wrote: I've prepared a very small test suite you can use to reproduce this issue in the easiest way: http://www.gaia-gis.it/merano_shp.zip -- shortly said: the test suite contains a SpatiaLite DB storing some 110+

Re: [Qgis-developer] SpatiaLite very slow with QGIS 1.7

2011-03-20 Thread a . furieri
On Sun, 20 Mar 2011 18:32:41 +0100, Martin Dobias wrote I have run it with a profiler and found out that it is (surprisingly) caused by QgsSnappingDialog. It is created on application startup, each time when a layer is added to map layer registry it updates itself Martin, sorry for the

Re: [Qgis-developer] SpatiaLite very slow with QGIS 1.7

2011-03-20 Thread Jürgen E . Fischer
Hi Martin, On Sun, 20. Mar 2011 at 18:32:41 +0100, Martin Dobias wrote: Thanks for the testing suite. I have run it with a profiler and found out that it is (surprisingly) caused by QgsSnappingDialog. It is created on application startup, each time when a layer is added to map layer registry

Re: [Qgis-developer] SpatiaLite very slow with QGIS 1.7

2011-03-19 Thread Cline, Royce L.
I have the problem with your QGIS v.1.7 r15108 dev build from Jan. 30 which uses QT 4.6.3. Since your QGIS 1.6 build of Jan. 29 also uses QT 4.6.3 and the same frameworks, doesn't that indicate it is not a QT problem? Also, it would appear that the Identify tool problem is not a QT problem

Re: [Qgis-developer] SpatiaLite very slow with QGIS 1.7

2011-03-19 Thread Cline, Royce L.
The problem also occurs in Windows. I used the OSGEO4W installer to install QGIS 1.6 and QGIS 1.7 r15533 into a VMware virtual machine running Windows XP. I created an 80 layer project file by duplicating the 4 layers in the db3.sqlite sample database. With rendering off, QGIS 1.6 loads the

Re: [Qgis-developer] SpatiaLite very slow with QGIS 1.7

2011-03-18 Thread Paolo Cavallini
Il giorno gio, 17/03/2011 alle 17.08 -0500, Cline, Royce L. ha scritto: Did further testing. The problem is a power function of the number of layers. Hi. Have you filled a ticket for this? Culd you please share a sample db, so we can test this on other OS? Thanks. -- http://www.faunalia.it/pc

Re: [Qgis-developer] SpatiaLite very slow with QGIS 1.7

2011-03-18 Thread Cline, Royce L.
I have not filed a ticket. It appears to be an OS X issue and I am waiting to see if William is able to resolve the issue. Is it better to file this issue and the Identify Tool problem as one or separate tickets as they are both QGIS 1.7 SpatiaLite issues? William was able to recreate the

Re: [Qgis-developer] SpatiaLite very slow with QGIS 1.7

2011-03-18 Thread Paolo Cavallini
Il giorno ven, 18/03/2011 alle 08.16 -0500, Cline, Royce L. ha scritto: I have not filed a ticket. It appears to be an OS X issue and I am waiting to see if William is able to resolve the issue. Is it better to file this issue and the Identify Tool problem as one or separate tickets as they

Re: [Qgis-developer] SpatiaLite very slow with QGIS 1.7

2011-03-18 Thread William Kyngesburye
On Mar 18, 2011, at 9:33 AM, Paolo Cavallini wrote: Il giorno ven, 18/03/2011 alle 08.16 -0500, Cline, Royce L. ha scritto: I have not filed a ticket. It appears to be an OS X issue and I am waiting to see if William is able to resolve the issue. Is it better to file this issue and the

Re: [Qgis-developer] SpatiaLite very slow with QGIS 1.7

2011-03-17 Thread Alessandro Furieri
Hi Noli, hi Royce, I've just spent several hours attempting to build the current QGIS-Trunk SVN snapshot on my cheap and old second hand MacMini (incredibly slow hardware, really an extenuating time consuming process ...). Anyway, these are my personal findings: - Mac Os X 10.5 Intel - not

Re: [Qgis-developer] SpatiaLite very slow with QGIS 1.7

2011-03-17 Thread MORREALE Jean Roc
Le 17/03/2011 17:04, Alessandro Furieri a écrit : Hi Noli, hi Royce, I've just spent several hours attempting to build the current QGIS-Trunk SVN snapshot on my cheap and old second hand MacMini (incredibly slow hardware, really an extenuating time consuming process ...). Anyway, these are my

Re: [Qgis-developer] SpatiaLite very slow with QGIS 1.7

2011-03-17 Thread William Kyngesburye
Some tests here, OSX 10.6.6: QGIS 1.6 with Sqlite/Spatialite 3.6.23/2.4rc3 framework add 20 spatialite layers: 2s quit: instant reopen: 2s QGIS 1.6 with Sqlite/Spatialite 3.7.4/2.4rc4 framework add 20 same layers: 2s quit: instant reopen: 3s QGIS 1.7 r15455 with Sqlite/Spatialite 3.7.4/2.4rc4

Re: [Qgis-developer] SpatiaLite very slow with QGIS 1.7

2011-03-17 Thread MORREALE Jean Roc
Le 17/03/2011 19:47, a.furi...@lqt.it a écrit : On Thu, 17 Mar 2011 18:48:51 +0100, MORREALE Jean Roc wrote Ticket #3002 may be linked, it is reproducible on windows/linux. Hi Jean Roc, ticket #3002 isn't related at all to SpatiaLite and/or to the QGIS own SpatiaLite data provider. I've

Re: [Qgis-developer] SpatiaLite very slow with QGIS 1.7

2011-03-17 Thread Cline, Royce L.
Is this possibly a 64 bit issue. I am assuming Sandro's mini is an original core duo and therefore his build is 32 bit. Probably his test of the Identify Tool and Selection tool was on 32 bit Windows. If so, this could be the differentiating factor. Royce On Mar 17, 2011, at 1:31 PM,

Re: [Qgis-developer] SpatiaLite very slow with QGIS 1.7

2011-03-17 Thread a . furieri
On Thu, 17 Mar 2011 21:12:59 +0100, MORREALE Jean Roc wrote Can you confirm that it is due to OGR ? ogr2ogr with SPATIALITE=yes is faster than QGIS 'save as' Not really sure about this: I personally ignore any implementation detail for this QGIS feature. Anyway FDO/OGR is strictly related

Re: [Qgis-developer] SpatiaLite very slow with QGIS 1.7

2011-03-17 Thread William Kyngesburye
I tried running QGIS in 32bit mode with no difference in times. And my QGIS 1.6 (assuming you're using that) is 64bit also. You could try it on your 1.7 build, if you compiled 32+64bit - Get Info on QGIS.app in the Finder, check Open in 32-bit mode. On Mar 17, 2011, at 3:27 PM, Cline, Royce

Re: [Qgis-developer] SpatiaLite very slow with QGIS 1.7

2011-03-17 Thread Cline, Royce L.
Did further testing. The problem is a power function of the number of layers. QGIS 1.7 r15529M. # layersload time quit time 40 2.3s1.6s 60 3.6s3.4 s 68 4.8s5.3s 76

[Qgis-developer] SpatiaLite very slow with QGIS 1.7

2011-03-16 Thread Cline, Royce L.
A problem I am having with QGIS 1.7 loading old projects I have tracked down to SpatiaLite. QGIS 1.7 was taking over 3 minutes to load a large project and over 12 minutes to quit QGIS. To test, I created a project with 124 layers from a SpatiaLite database. QGIS 1.6 took 3.9 seconds to import