Hi Paolo, Which email are you refering to?
This one? http://lists.osgeo.org/pipermail/qgis-user/2009-April/005183.html Here is what I did so far: I saved the project as a different name. So far this did not speed things up. I did a project file comparison in the OxygenXML editor. There are only minor differences, like <provider>postgres</provider> changed to <provider encoding="System">postgres</provider> and in <patialrefsys>: <geographicflag>true</geographic> changed to <geographicflag>false</geographic> for some reasons I don't know. I did not recreate the project so far. It is not very easy. I spent hours of work to define the project's symbolization, including complex text symbolization, SVG symbols, a lot of unique-value to point/line symbol assignments, etc. It is not something I can redo in a couple minutes. I have to mention that I use a lot of views, which are again using a lot of table joins. However, all of my tables have primary keys (of PostgreSQL type integer) and the views are registered in the public.geometry_columns table. Jürgen suggested to build a debug build - which I did today. Here is what I observed from the debug output: At least 90% or more of the time is spent parsing the table PostgreSQL table definitions. I get outputs like: .* "?ww_utilisation_tbd"?\."?value"? AS "?(\w+)"?,* .* .* "?ww_reinstatement_tbd"?\."?value"? AS "?(\w+)"?,* .* Both are joined tables in a view definition. It takes approx. a second per debug lines and there are at least 100-200 of these messages (I could not count it). As I said - I can make the data and project file available to selected developers. I can't upload this to the general public as it contains all of community's survey and waste-water data - which is not available for free to the general public (unfortunately). However, if a developer has the time to look into the issue, I can make a copy available. As it looks like currently, Jürgen offered to help me on the issue. Thanks, Andreas On Fri, April 24, 2009 9:51 am, Paolo Cavallini wrote: > Andreas Neumann ha scritto: >> I hope that we can find a solution - because in case I want to do a >> presentation of QGIS I cannot afford to wait 3-4 minutes for the project >> to start up. Also, I was planning to use this project as a quick viewing >> and printing solution. If I cannot get it to load in 10-30 seconds I >> won't get acceptance from my work colleagues. > > I wrote a few suggestions in an earlier mail: did you check? > Please do and report the results. > Thanks. > -- > Paolo Cavallini: http://www.faunalia.it/pc > _______________________________________________ > Qgis-user mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/qgis-user > -- Andreas Neumann http://www.carto.net/neumann/ http://www.svgopen.org/ _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
