[Qgis-user] Project takes very long to load
a.neumann at carto.net
Tue Apr 28 06:25:57 EDT 2009
Did you re-save the project in another name or saved it again?
In any case, I would open the project file in a text/XML editor and make
sure that the key='gid' (or similar column name) is present in the
Here is an example:
<datasource>dbname='world' host=localhost port=5432 user='an'
sslmode=disable key='gid' table="countries"."country_border" (the_geom)
Maybe you need to manually introduce the key='somekey' in a text/XML editor.
Can you test again and report if this helped?
On Tue, April 28, 2009 12:08 pm, Nikos Alexandris wrote:
>> I'd like to inform you that JÃ¼rgen provided a fix for the problem,
>> is now in trunk. Thank you JÃ¼rgen!
>> The problem really was the primary key detection, which was checked with
>> every project load and took very long for complex views/tables. Now the
>> pkey check is done with the initial layer loading and stored in the
>> project file. When loading the layer it seems like it first starts the
>> primary key detection with the stored key attribute from the project
>> and stops searching for further keys after it confirmed that the
>> key works - at least this is how I understand the current behavior in
>> trunk - JÃ¼rgen - please correct me if I am wrong.
>> Anyway - the project that previously loaded in 3-4 minutes now loads in
>> approx. 10 seconds.
> Hi Andreas,
> I just recompiled qgis_unstable. Unfortunately for me it doesn't improve
> load time of old(er) projects.
> Ubuntu Jaunty 64-bit
More information about the Qgis-user