[Qgis-developer] SpatiaLite very slow with QGIS 1.7

[William Kyngesburye]

Oh yeah, that makes a difference.  I didn't have a spatialite DB with 80 layers, but I added the same 20 from before 4x.  While I couldn't test loading all 80 at once, I could test the quitting aspect.

QGIS 1.6-1, spatialite 2.4rc3 (should be same as the 1.6 that's working for you)

- quits instantly

QGIS 1.6-2, spatialite 2.4rc4

- quits instantly

QGIS 1.7 r15455, spatialite 2.4rc4 (same binary as above)

- takes 11s to quit

So, this points to a QGIS problem.  I'll work on an updated SVN build and try that...

On Mar 17, 2011, at 5:08 PM, Cline, Royce L. wrote:

> Did further testing. The problem is a power function of the number of layers. 
> 
> QGIS 1.7 r15529M. 
> # layers        load time       quit time
> 40 			2.3s 		1.6s
> 60			3.6s 		3.4 s
> 68			4.8s			5.3s
> 76			6.2s			8.9s
> 84			7.9s			19.6s
> 92			10.9		36.7s
> 100			14.1s		57.7s
> 108			18.8s		82.2s
> 
> QGIS 1.6
> # layers        load time       quit time
> 108			3.6s		instantaneous 
> 
> Both versions of QGIS using the same frameworks. Layer differences should not impact the times. The layers are in sets of 4 with the latter layer datasets added being very similar in the data they contain to the first layer datasets added.
> 
> Royce
> 
> 
> 
> On Mar 17, 2011, at 3:47 PM, William Kyngesburye wrote:
> 
>> 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 L. wrote:
>> 
>>> 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, William Kyngesburye wrote:
>>> 
>>> 
>>>> 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 framework
>>>> 
>>>> add same 20 layers: 2s
>>>> quit: instant
>>>> reopen: 3s
>>>> 
>>>> I'll try updating my SVN and rebuilding and see if there is a change.
>>>> 
>>>> On Mar 17, 2011, at 11:04 AM, Alessandro Furieri wrote:
>>>> 
>>>>> 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 using frameworks at all (only the Qt one)
>>>>> - using MacPorts libraries instead
>>>>> - and using INTERNAL SpatiaLite (2.4.0-RC4)
>>>>> 
>>>>> + QGIS on Mac Os X runs exactly as it run on Windows
>>>>> + I was completely unable to observe any issue about
>>>>> the Identify tool
>>>>> + opening an 80+ layers DB takes an absolutely
>>>>> reasonable time
>>>>> + closing the same DB is a quite immediate process
>>>>> 
>>>>> So, I'm completely unable to tell you why the 'standard'
>>>>> QGIS distribution for Mac Os X shows so many problems
>>>>> related to SpatiaLite 2.4.0-RC4 as you've reported.
>>>>> 
>>>>> At this point I strongly suspect that something is
>>>>> broken or misconfigured in the most recent SpatiaLite
>>>>> Mac Os X framework, because simply avoiding to use
>>>>> this one and building so to use the INTERNAL spatialite
>>>>> instead fixes any issue.
>>>>> 
>>>>> bye Sandro
>> 
>> -----
>> William Kyngesburye <kyngchaos*at*kyngchaos*dot*com>
>> http://www.kyngchaos.com/
>> 
>> [Trillian]  What are you supposed to do WITH a maniacally depressed robot?
>> 
>> [Marvin]  You think you have problems?  What are you supposed to do if you ARE a maniacally depressed robot?  No, don't try and answer, I'm 50,000 times more intelligent than you and even I don't know the answer...
>> 
>> - HitchHiker's Guide to the Galaxy
>> 
>> 
> 
> 
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer

-----
William Kyngesburye <kyngchaos*at*kyngchaos*dot*com>
http://www.kyngchaos.com/

Earth: "Mostly harmless"

- revised entry in the HitchHiker's Guide to the Galaxy