Re: [Maposmatic-dev] Re: [cairo] Cairo & libpng/zlib parameters

[David MENTRE]

Hello Chris,

Chris Wilson <address@hidden> writes:

> Those that are slow to render are probably the best to look at -
> though we actually want to identify ones where it is Cairo that is the
> bottleneck (for the purposes of improving Cairo).

Here is the 10 longest to render (we cap maximum rendering time at 20
minutes):

maposmatic-prod=> select maptitle, endofrendering_time - startofrendering_time 
as time, administrative_city, lat_upper_left, lon_upper_left, lat_bottom_right, 
lon_bottom_right  from maposmatic_maprenderingjob where status = 2 and 
resultmsg='ok' order by time desc limit 10 ;

                   maptitle                    |      time       |              
administrative_city              | lat_upper_left | lon_upper_left | 
lat_bottom_right | lon_bottom_right 
-----------------------------------------------+-----------------+-----------------------------------------------+----------------+----------------+------------------+------------------
 Nantes Agglomération                          | 00:19:59.747315 |              
                                 |         47.313 |        -1.7734 |          
47.1165 |          -1.4628
 Seattle, Washington, United States of America | 00:19:39.462928 | Seattle, 
Washington, United States of America |                |                |        
          |                 
 Kemmern                                       | 00:19:37.664684 |              
                                 |          49.96 |        10.8637 |          
49.9484 |          10.8894
 Paris                                         | 00:18:58.93082  | Paris        
                                 |                |                |            
      |                 
 Utrecht, Bestuur Regio Utrecht, Nederland     | 00:18:46.028076 | Utrecht, 
Bestuur Regio Utrecht, Nederland     |                |                |        
          |                 
 Le Creusot, Saône-et-Loire, Bourgogne, France | 00:17:49.678245 | Le Creusot, 
Saône-et-Loire, Bourgogne, France |                |                |           
       |                 
 Paris, 75, Île-de-France, France              | 00:17:36.245691 | Paris, 75, 
Île-de-France, France              |                |                |          
        |                 
 Nantes Métropole                              | 00:17:32.242042 |              
                                 |         47.313 |        -1.7425 |          
47.1319 |          -1.4424
 Almere, Flevoland, Nederland                  | 00:17:27.151452 | Almere, 
Flevoland, Nederland                  |                |                |       
           |                 
 Utrecht, Bestuur Regio Utrecht, Nederland     | 00:17:08.27529  | Utrecht, 
Bestuur Regio Utrecht, Nederland     |                |                |        
          |                 


I can't say if for those jobs Cairo is the bottleneck, let me know. Let
me know also if you need more information.

Best regards,
d.
-- 
GPG/PGP key: A3AD7A2A David MENTRE <address@hidden>
 5996 CC46 4612 9CA4 3562  D7AC 6C67 9E96 A3AD 7A2A