[Cartoweb-users] Slow Project more information

Mon Aug 8 04:39:46 EDT 2005

Hi Again,

1. I'm working on a pc win2000 CPU 1.5GHz 392.688 KB RAM
2. My installation is WAMP5 (APACHE 1.3.33, PHP 5.0.4, SQLITEMANAGER 1.0.4, MYSQL   4.1.10a)
3. My project is for the intranet of my entreprise (for the moment my project is only for a demo)
4. I use only shapefiles (the smaller is 311 bytes and the bigger is 11,1 Mb)
5. here is my mapfile 

    MAP
  #  QUERY
  NAME "bruxelles"
  EXTENT 145691.587 164468.490 155263.057 178821.756
  SIZE 3000 2000 
  SHAPEPATH "data"
  SYMBOLSET "symbols.sym"
  FONTSET "fonts.txt"
  UNITS METERS
    LEGEND
    STATUS ON
    KEYSIZE 18 13
    POSTLABELCACHE true

    LABEL
      TYPE BITMAP
      SIZE MEDIUM
      POSITION cc
      COLOR 0 0 89
    END
  END
  #LEGEND
  #
  # Start of scalebar
  #

OUTPUTFORMAT
 NAME png
 DRIVER "GD/PNG"
 MIMETYPE "image/png"
 IMAGEMODE PC256
 EXTENSION "png"
END 

  SCALEBAR
    STATUS ON
    COLOR 255 255 255
    OUTLINECOLOR 0 0 0
    BACKGROUNDCOLOR 0 0 0
    IMAGECOLOR 255 255 255
    UNITS meters
    INTERVALS 10
    #LABEL
    SIZE 350 5 
    LABEL
      SIZE SMALL
      COLOR 0 0 0
    END
  END
REFERENCE
    IMAGE images/keymap.gif
    EXTENT 145691.587 164468.490 155263.057 178821.756
    STATUS ON
    COLOR -1 -1 -1
    OUTLINECOLOR 180 60 60
    SIZE 100 70
  END

LAYER
  NAME a_ev
  TYPE Polygon
  STATUS on
  DATA a_ev2.shp
  TRANSPARENCY 70
    CLASSITEM "Layer"
      CLASS
	  NAME "Zones de sports ou de loisirs en plein air"
        EXPRESSION 'Level 2'
        COLOR 155 255 6
        OUTLINECOLOR 0 0 0
          STYLE
           SYMBOL "Sport"
           COLOR 0 0 0
           OUTLINECOLOR 0 0 0
          END 
     END  # CLASS

      CLASS
	  NAME "Zones de cimeti&#232;res"
        EXPRESSION 'Level 3'
        COLOR 155 255 6
        OUTLINECOLOR 0 0 0
          STYLE
           SYMBOL "cimetiere"
	     COLOR 0 0 0
           OUTLINECOLOR 0 0 0
          END 
      END  # CLASS

      CLASS
	  NAME "Zones vertes"
        EXPRESSION 'Level 4'
        COLOR 0 255 0
        OUTLINECOLOR 0 0 0
      END  # CLASS

      CLASS
	  NAME "Zones agricoles"
        EXPRESSION 'Level 5'
        COLOR 214 255 168
        OUTLINECOLOR 0 0 0
      END  # CLASS

      CLASS
	  NAME "Zones for&#234;sti&#232;res"
        EXPRESSION 'Level 6'
        COLOR 0 109 85
        OUTLINECOLOR 0 0 0
      END  # CLASS

      CLASS
	  NAME "Zones vertes de haute qualit&#233; biologique"
        EXPRESSION 'Level 7'
        COLOR 0 255 0
        OUTLINECOLOR 0 0 0
          STYLE
            SYMBOL "biol"
            SIZE 30
	      color 0 0 0
            outlinecolor 0 0 0
          END 
      END  # CLASS

      CLASS
	  NAME "Zones de parcs"
        EXPRESSION 'Level 9'
        COLOR 155 255 6
        OUTLINECOLOR 0 0 0
      END  # CLASS

END  # LAYER

LAYER
  NAME a_affect
  TYPE Polygon
  STATUS on
  TRANSPARENCY 70
  DATA a_affect
    CLASSITEM "Layer"
      CLASS
        NAME "Zones d'hab. a pr&#233;dominance  r&#233;sidentielle"
        EXPRESSION 'Level 1'
        COLOR 255 255 170
      END  # CLASS

      CLASS
        NAME "Zones d'habitation" 
        EXPRESSION 'Level 2'
        COLOR 246 194 73
      END  # CLASS

      CLASS
        NAME "Zones mixtes"
        EXPRESSION 'Level 3'
        COLOR 220 116 17
      END  # CLASS

      CLASS
        NAME "Zones de fortes mixit&#233;"
        EXPRESSION 'Level 4'
        COLOR 95 58 0
      END  # CLASS

      CLASS
        NAME "Zones d'&#233;quipements d'inter&#234;ts collectif ou de service public"
        EXPRESSION 'Level 6'
        COLOR 168 255 255
      END  # CLASS

      CLASS
        NAME "Zones administratives"
        EXPRESSION 'Level 7'
        COLOR 140 150 203
      END  # CLASS

      CLASS
        NAME "Zones d'industries urbaines"
        EXPRESSION 'Level 8'
        COLOR 225 89 255
      END  # CLASS

      CLASS
        NAME "Zones d'activit&#233;s portuaires et de transports"
        EXPRESSION 'Level 9'
        COLOR 15 101 255
      END  # CLASS

      CLASS
        NAME "Zones de chemin de fer"
        EXPRESSION 'Level 10'
        COLOR 178 178 178
      END  # CLASS

        METADATA
	  "id_attribute_string" "ID|string"
	  "query_returned_attributes" "COLOR" 

      END
    TEMPLATE "ttt"

END  # LAYER

LAYER
  NAME a_structu
  TYPE Polygon
  STATUS on
  TRANSPARENCY 70
  DATA "a_structu"
      CLASS
        Name 'Espace structurant'
        COLOR 255 255 0
        OUTLINECOLOR 255 255 0
      END  # CLASS
END  # LAYER

LAYER
  NAME a_comm
  TYPE Polygon
  STATUS on
  TRANSPARENCY 70
  DATA a_comm
      CLASS
        Name 'Liser&#233;s de noyau commercial'
        COLOR 0 0 255
        OUTLINECOLOR 0 0 255
      END  # CLASS
END  # LAYER

LAYER
  NAME a_eau
  TYPE Polygon
  STATUS on
  TRANSPARENCY 70
  DATA a_eau
      CLASS
        Name 'Eau'
        COLOR 0 182 255
        OUTLINECOLOR 0 182 255
      END  # CLASS
END  # LAYER

LAYER
  NAME a_zir
  TYPE Polygon
  STATUS on
  DATA a_zir

          CLASS
             NAME "Zones d'inter&#234;t r&#233gional"
                STYLE
                 SYMBOL "zir2"
	           COLOR 255 210 128
                 OUTLINECOLOR 0 0 0
                 ANGLE 135
                 SIZE 10
                 WIDTH 4
                END 
         END  # CLASS       
END  # LAYER

LAYER
  NAME a_zirad
  TYPE Polygon
  STATUS on
  DATA a_zirad

          CLASS
              NAME "Zones d'inter&#234;t r&#233gional &#224; am&#233;nagement diff&#233;r&#233;"
                STYLE
                 SYMBOL "zirad"
	           COLOR 0 0 0
                 OUTLINECOLOR 0 0 0
                 SIZE 10
                END 

         END  # CLASS       
END  # LAYER

LAYER
    NAME "parcelle"
    STATUS ON
    DATA "074"
    TYPE polygon
    UNITS METERS
    SIZEUNITS METERS
        CLASS
          STYLE
           OUTLINECOLOR 150 150 150
          END
        END  # CLASS       
        METADATA
	  "id_attribute_string" "NRPARC|string"
	  "query_returned_attributes" "CPNC LINK_CP" 
        END
        TEMPLATE "ttt"   
END  # LAYER

    LAYER
    NAME "limitecom"
    STATUS ON
    DATA "limcom"
    TYPE LINE
    UNITS METERS
    SIZEUNITS METERS
        CLASS
         STYLE
          SYMBOL 7
          OUTLINECOLOR 0 0 0
          SIZE 7
         END
        END # CLASS
    METADATA
    "id_attribute_string" "LAYER|string"
    "query_returned_attributes" "MUFN" 
    END
    TEMPLATE "ttt"
END  # LAYER

LAYER
    NAME "Rues"
    STATUS ON
    DATA "ruesfr"
    TYPE ANNOTATION
    UNITS METERS
    SIZEUNITS METERS
    MAXSCALE 2501
    LABELITEM "TEXT"
    CLASS
      LABEL
        TYPE TRUETYPE
        FONT "arial"
        SIZE 2
        MINSIZE 5
        MAXSIZE 15
        POSITION CC
        ANGLE AUTO
        MINDISTANCE 500
        COLOR 0 0 0
        ANTIALIAS TRUE
        PARTIALS TRUE
      END
    END # CLASS
END  # LAYER

LAYER
    NAME "nr_parcelles"
    STATUS ON
    DATA "074"
    TYPE POLYGON
    UNITS METERS
    SIZEUNITS METERS
    MAXSCALE 1001
    LABELITEM "NRPARC"
    CLASS
      LABEL
        TYPE TRUETYPE
        FONT "arial"
        MINSIZE 10
        MAXSIZE 500
        POSITION CC
        ANGLE AUTO
        COLOR 255 0 0
        PARTIALS TRUE
        FORCE TRUE
      END
    END # CLASS
END  # LAYER

LAYER
  NAME a_pichee
  TYPE Polygon
  STATUS on
  TRANSPARENCY 80
  DATA a_pichee
      CLASS
        Name 'PICHEE'
        STYLE
	    SYMBOL "pichee"
          SIZE 8
          COLOR 0 0 0
          OUTLINECOLOR 0 0 0
          END
       END  # CLASS
END  # LAYER

LAYER
    NAME "zirid"
    STATUS ON
    DATA "a_zir"
    TYPE POLYGON
    UNITS METERS
    SIZEUNITS METERS
    LABELITEM "ID"
        CLASS
         LABEL
         TYPE TRUETYPE
         FONT "arial"
	   SIZE 15
         POSITION CC
         ANGLE AUTO
         COLOR 0 0 0
         PARTIALS TRUE
         FORCE TRUE
         END # LABEL
         STYLE
         SYMBOL "limzir"
         OUTLINECOLOR 0 0 0
         END # STYLE
        END # CLASS
END  # LAYER

LAYER
  NAME a_parking
  TYPE Point
  STATUS on
  DATA a_parking
  TRANSPARENCY 50
      CLASS
        Name 'Parking de transit'
        COLOR 0 255 255
        OUTLINECOLOR 0 0 0
        STYLE
        SYMBOL "Parking"
        COLOR 0 255 255
        OUTLINECOLOR 0 0 0
        END # STYLE
     END  # CLASS
END  # LAYER

LAYER
  NAME a_pastille
  TYPE Point
  STATUS on
  DATA a_pastille
      CLASS
        Name 'Points de variation de mixit&#233;'
        COLOR 0 0 0
        OUTLINECOLOR 0 0 0
        STYLE
        SYMBOL "pastille"
        SIZE 5
        COLOR 0 0 0
        OUTLINECOLOR 0 0 0
        END # STYLE
      END  # CLASS
END  # LAYER

LAYER
  NAME a_gal
  TYPE Point
  STATUS on
  DATA a_gal
      CLASS
        Name 'Galeries commercantes'
        COLOR 0 0 0
        OUTLINECOLOR 0 0 0
        STYLE
        SYMBOL "Galerie"
        Size 8
        COLOR 0 0 0
        END # STYLE
     END  # CLASS
END  # LAYER

LAYER
  NAME "a_kr"
  TYPE POINT
  STATUS on
  DATA a_kr
  LABELITEM 'kr'
      CLASS
        Name 'Domaine Royal'
        COLOR 0 0 0
        OUTLINECOLOR 0 0 0
        STYLE
        SYMBOL "KR"
        Size 9
        COLOR 0 0 0
        END # STYLE
     END  # CLASS
END  # LAYER

END # MAPFILE

6. i know that a optimization must be done but i couldn't find the file shp2tile for windows.... i don't have linux..

If you need some more informations, there are no problem because it is very important for me to develop a working demo of that....

In advance thanks for all

Regards

Caussin David
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/cartoweb-users/attachments/20050808/5fa93012/attachment-0001.html