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 > [email protected] > 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 _______________________________________________ Qgis-developer mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-developer
