Profiling de ZdS

A la recherche des goulots d'étranglements

L'auteur de ce sujet a trouvé une solution à son problème.
Staff
Auteur du sujet

Comme je l'avais déjà initié pendant la beta privée, j'ouvre un topic pour partager les résultats de profiling sur ZdS. J'ai mis en place un léger outils de profilage en tant qu'intergiciel basé sur cette expérience, qui tourne actuellement uniquement sur la prod et n'altère pas les perfs de celui-ci (car il ne se déclenche que quand j'en donne l'ordre).

Le principe est simple, on peut facilement voir les résultats d’exécution d'une page précise. Il y'a pas foule d'information, mais on peut déjà se faire une idée.

J'ai donc pris certaines pages types, et voici les logs de profiling.

Notons bien que ce profiling est réalisé jeudi 24/07/2014 à 15h 30, je regarderai les stats plus tard pour savoir combien de sessions était actives.

La page d'acceuil

url : http://zestedesavoir.com/

Temps de chargement coté back-end : 0.801 sec

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
         70346 function calls (68217 primitive calls) in 0.801 seconds

   Ordered by: internal time, call count

   ncalls  tottime  percall  cumtime  percall filename:lineno(function)
       38    0.027    0.001    0.027    0.001 /usr/lib/python2.7/json/decoder.py:371(raw_decode)
       63    0.020    0.000    0.024    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb/cursors.py:315(_do_query)
    101/2    0.017    0.000    0.074    0.037 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:241(parse)
  300/228    0.014    0.000    0.014    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/stream.py:199(read)
      673    0.012    0.000    0.042    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/functional.py:197(wrapper)
      105    0.011    0.000    0.036    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/core/urlresolvers.py:396(_reverse_with_prefix)
     1500    0.011    0.000    0.011    0.000 /opt/zdsenv/lib/python2.7/encodings/utf_8.py:15(decode)
      242    0.011    0.000    0.030    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:213(clone)
      213    0.010    0.000    0.017    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/base.py:325(__init__)
     1516    0.009    0.000    0.009    0.000 /opt/zdsenv/lib/python2.7/posixpath.py:68(join)
      687    0.008    0.000    0.008    0.000 /opt/zdsenv/lib/python2.7/posixpath.py:321(normpath)
2116/2115    0.008    0.000    0.011    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/encoding.py:84(force_text)
       39    0.008    0.000    0.010    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/git/config.py:195(_read)
       59    0.008    0.000    0.017    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:259(get_default_columns)
    110/1    0.007    0.000    0.480    0.480 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:836(render)
      121    0.007    0.000    0.010    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/backends/mysql/compiler.py:6(resolve_columns)
  597/184    0.007    0.000    0.009    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:817(get_nodes_by_type)
      271    0.007    0.000    0.007    0.000 /opt/zdsenv/lib/python2.7/genericpath.py:15(exists)
      481    0.007    0.000    0.007    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/safestring.py:104(mark_safe)
      301    0.006    0.000    0.144    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:752(_resolve_lookup)
    69/63    0.006    0.000    0.067    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:65(as_sql)
       84    0.006    0.000    0.036    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:1011(build_filter)
     35/8    0.006    0.000    0.186    0.023 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/defaulttags.py:142(render)
       24    0.005    0.000    0.005    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/pack.py:364(_read_fanout)
      350    0.005    0.000    0.005    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/text.py:340(smart_split)
      171    0.005    0.000    0.165    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/query.py:160(iterator)
      531    0.005    0.000    0.005    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:301(extend_nodelist)
      636    0.005    0.000    0.005    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/datastructures.py:127(__init__)
      179    0.005    0.000    0.011    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:687(__init__)
    448/1    0.005    0.000    0.480    0.480 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/debug.py:76(render_node)
      175    0.005    0.000    0.018    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:538(__init__)
      646    0.005    0.000    0.013    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/debug.py:28(create_token)
      205    0.005    0.000    0.107    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/debug.py:86(render)
      154    0.004    0.000    0.007    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/util.py:181(file_contents_ro_filepath)
      646    0.004    0.000    0.008    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:201(create_token)

 ---- By file ----

      tottime
10.7%   0.080 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py
 7.2%   0.054 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py
 5.0%   0.037 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py
 5.0%   0.037 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb/cursors.py
 3.7%   0.028 /usr/lib/python2.7/json/decoder.py
 3.2%   0.024 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/query.py
 3.2%   0.024 /opt/zdsenv/lib/python2.7/posixpath.py
 2.9%   0.022 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/debug.py
 2.8%   0.021 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/stream.py
 2.3%   0.017 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/functional.py
 2.3%   0.017 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/where.py
 2.1%   0.016 /opt/zdsenv/local/lib/python2.7/site-packages/django/core/urlresolvers.py
 2.0%   0.015 /opt/zdsenv/local/lib/python2.7/site-packages/git/config.py
 1.9%   0.014 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/datastructures.py
 1.7%   0.013 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/defaulttags.py
 1.7%   0.013 /opt/zdsenv/ZesteDeSavoir/zds/tutorial/models.py
 1.7%   0.013 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/base.py
 1.7%   0.013 /opt/zdsenv/lib/python2.7/genericpath.py
 1.5%   0.011 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/fields/related.py
 1.5%   0.011 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/text.py
 1.5%   0.011 /opt/zdsenv/lib/python2.7/encodings/utf_8.py
 1.3%   0.010 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/db/loose.py
 1.3%   0.010 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/util.py
 1.1%   0.008 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/db/base.py
 1.1%   0.008 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py
 0.9%   0.007 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/db/pack.py
 0.9%   0.007 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/tree.py
 0.9%   0.007 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/safestring.py
 0.9%   0.007 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/backends/mysql/compiler.py
 0.9%   0.007 /opt/zdsenv/lib/python2.7/re.py
 0.8%   0.006 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/pack.py
 0.8%   0.006 /opt/zdsenv/local/lib/python2.7/site-packages/git/objects/base.py
 0.8%   0.006 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/options.py
 0.8%   0.006 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/fields/__init__.py
 0.7%   0.005 /usr/lib/python2.7/glob.py
 0.7%   0.005 /opt/zdsenv/local/lib/python2.7/site-packages/git/repo/base.py
 0.7%   0.005 /opt/zdsenv/local/lib/python2.7/site-packages/git/odict.py
 0.7%   0.005 /opt/zdsenv/local/lib/python2.7/site-packages/git/objects/tree.py
 0.7%   0.005 /opt/zdsenv/local/lib/python2.7/site-packages/git/objects/commit.py
 0.7%   0.005 /opt/zdsenv/local/lib/python2.7/site-packages/easy_thumbnails/files.py

 ---- By group ---

      tottime
26.8%   0.200 /opt/zdsenv/local/lib/python2.7/site-packages/django/db
16.9%   0.126 /opt/zdsenv/local/lib/python2.7/site-packages/django/template
11.5%   0.086 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils
 7.0%   0.052 /opt/zdsenv/lib/python2.7
 5.8%   0.043 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb
 5.2%   0.039 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb
 3.7%   0.028 /usr/lib/python2.7/json
 3.6%   0.027 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/db
 3.1%   0.023 /opt/zdsenv/local/lib/python2.7/site-packages/git/objects
 2.9%   0.022 /opt/zdsenv/local/lib/python2.7/site-packages/git
 2.8%   0.021 /usr/lib/python2.7
 2.4%   0.018 /opt/zdsenv/local/lib/python2.7/site-packages/django/core
 2.0%   0.015 /opt/zdsenv/local/lib/python2.7/site-packages/easy_thumbnails
 1.7%   0.013 /opt/zdsenv/ZesteDeSavoir/zds/tutorial
 1.5%   0.011 /opt/zdsenv/lib/python2.7/encodings
 1.1%   0.008 /opt/zdsenv/local/lib/python2.7/site-packages/git/repo
 0.5%   0.004 /opt/zdsenv/local/lib/python2.7/site-packages/django/dispatch
 0.5%   0.004 /opt/zdsenv/ZesteDeSavoir/zds/utils
 0.3%   0.002 /opt/zdsenv/local/lib/python2.7/site-packages/django/conf
 0.3%   0.002 /opt/zdsenv/ZesteDeSavoir/zds/utils/templatetags
 0.1%   0.001 
 0.1%   0.001 /opt/zdsenv/local/lib/python2.7/site-packages/smmap
 0.1%   0.001 /opt/zdsenv/ZesteDeSavoir/zds/article
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/git/refs
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/templatetags
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/shortcuts
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/middleware
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/http
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/contrib
 0.0%   0.000 /opt/zdsenv/ZesteDeSavoir/zds/pages
 0.0%   0.000 /opt/zdsenv/ZesteDeSavoir/zds/member
 0.0%   0.000 /opt/zdsenv/ZesteDeSavoir/zds/forum

Les forums

Liste des forums

url : http://zestedesavoir.com/forums/

Temps de chargement coté back-end : 2.186 sec

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
         228575 function calls (225027 primitive calls) in 2.186 seconds

   Ordered by: internal time, call count

   ncalls  tottime  percall  cumtime  percall filename:lineno(function)
      341    0.075    0.000    0.097    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb/cursors.py:315(_do_query)
      672    0.064    0.000    0.090    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/backends/mysql/compiler.py:6(resolve_columns)
      514    0.056    0.000    0.134    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:259(get_default_columns)
     1120    0.049    0.000    0.143    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:213(clone)
    11063    0.043    0.000    0.061    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:49(quote_name_unless_alias)
      549    0.036    0.000    0.114    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/where.py:166(make_atom)
      956    0.036    0.000    0.054    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/base.py:325(__init__)
      347    0.035    0.000    0.175    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:177(get_columns)
      437    0.035    0.000    0.095    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/fields/related.py:1071(get_lookup_constraint)
  347/341    0.033    0.000    0.586    0.002 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:65(as_sql)
     1178    0.032    0.000    0.076    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:1251(names_to_path)
     1178    0.031    0.000    0.160    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:1331(setup_joins)
     6383    0.030    0.000    0.030    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py:294(quote_name)
      555    0.030    0.000    0.275    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:1011(build_filter)
   334/57    0.027    0.000    0.143    0.003 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:618(fill_related_selections)
      341    0.027    0.000    0.078    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb/cursors.py:324(_fetch_row)
     3175    0.025    0.000    0.025    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/datastructures.py:127(__init__)
     2240    0.025    0.000    0.050    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/datastructures.py:245(copy)
     1604    0.024    0.000    0.037    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:833(join)
     4985    0.023    0.000    0.023    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/tree.py:18(__init__)
      565    0.023    0.000    0.035    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:1383(trim_joins)
      909    0.021    0.000    1.021    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/query.py:160(iterator)
     1114    0.020    0.000    0.036    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/fields/related.py:1054(get_path_info)
      347    0.019    0.000    0.029    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:509(get_from_clause)
      909    0.019    0.000    0.862    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:706(results_iter)
      341    0.018    0.000    0.516    0.002 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/fields/related.py:299(__get__)
      349    0.017    0.000    0.033    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:105(__init__)
      851    0.016    0.000    0.016    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb/times.py:44(DateTime_or_None)
2249/2242    0.016    0.000    0.035    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/where.py:292(clone)
     5584    0.016    0.000    0.056    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:919(join_parent_model)
     5279    0.016    0.000    0.016    0.000 :8(__new__)
     3175    0.016    0.000    0.016    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/datastructures.py:122(__new__)
     2066    0.015    0.000    0.049    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/where.py:49(_prepare_data)
     1016    0.015    0.000    0.146    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/query.py:840(_clone)
     2072    0.015    0.000    0.064    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/tree.py:87(add)

 ---- By file ----

      tottime
16.8%   0.357 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py
13.7%   0.293 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py
 8.4%   0.180 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb/cursors.py
 6.5%   0.138 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/fields/related.py
 5.4%   0.116 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/query.py
 4.3%   0.091 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/where.py
 4.2%   0.089 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/datastructures.py
 3.5%   0.074 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py
 3.2%   0.069 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/fields/__init__.py
 3.0%   0.064 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/backends/mysql/compiler.py
 2.6%   0.056 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py
 2.5%   0.053 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/options.py
 2.4%   0.051 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/tree.py
 1.9%   0.041 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/base.py
 1.5%   0.033 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/debug.py
 1.5%   0.031 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/functional.py
 1.4%   0.030 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/backends/__init__.py
 1.2%   0.026 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/utils.py
 1.1%   0.024 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/query_utils.py
 1.1%   0.023 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb/connections.py
 0.9%   0.020 /opt/zdsenv/ZesteDeSavoir/zds/forum/models.py
 0.9%   0.019 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/backends/util.py
 0.8%   0.017 /opt/zdsenv/local/lib/python2.7/site-packages/django/core/urlresolvers.py
 0.8%   0.016 
 0.8%   0.016 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb/times.py
 0.7%   0.015 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/defaulttags.py
 0.6%   0.013 /opt/zdsenv/lib/python2.7/encodings/utf_8.py
 0.6%   0.012 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/pack.py
 0.5%   0.011 /opt/zdsenv/local/lib/python2.7/site-packages/django/dispatch/dispatcher.py
 0.5%   0.010 /usr/lib/python2.7/copy.py
 0.5%   0.010 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/six.py
 0.4%   0.009 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/loaders/filesystem.py
 0.4%   0.009 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/loader.py
 0.4%   0.008 /opt/zdsenv/local/lib/python2.7/site-packages/django/conf/__init__.py
 0.4%   0.008 /opt/zdsenv/lib/python2.7/abc.py
 0.3%   0.007 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/manager.py
 0.3%   0.006 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/translation/trans_real.py
 0.3%   0.006 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/text.py
 0.3%   0.006 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/itercompat.py
 0.3%   0.006 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/encoding.py

 ---- By group ---

      tottime
65.2%   1.389 /opt/zdsenv/local/lib/python2.7/site-packages/django/db
10.6%   0.226 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils
10.4%   0.222 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb
 7.0%   0.149 /opt/zdsenv/local/lib/python2.7/site-packages/django/template
 1.1%   0.023 /opt/zdsenv/lib/python2.7
 0.9%   0.020 /opt/zdsenv/ZesteDeSavoir/zds/forum
 0.8%   0.017 /usr/lib/python2.7
 0.8%   0.017 /opt/zdsenv/local/lib/python2.7/site-packages/django/core
 0.8%   0.016 
 0.6%   0.013 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb
 0.6%   0.013 /opt/zdsenv/lib/python2.7/encodings
 0.5%   0.011 /opt/zdsenv/local/lib/python2.7/site-packages/django/dispatch
 0.4%   0.008 /opt/zdsenv/local/lib/python2.7/site-packages/django/conf
 0.1%   0.003 /opt/zdsenv/ZesteDeSavoir/zds/utils/templatetags
 0.1%   0.002 /opt/zdsenv/ZesteDeSavoir/zds/utils
 0.0%   0.001 /opt/zdsenv/local/lib/python2.7/site-packages/smmap
 0.0%   0.001 /opt/zdsenv/local/lib/python2.7/site-packages/git
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/db
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/git/repo
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/git/refs
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/git/objects
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/templatetags
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/shortcuts
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/middleware
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/http
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/contrib
 0.0%   0.000 /opt/zdsenv/ZesteDeSavoir/zds/member

Liste des topics

url : http://zestedesavoir.com/forums/communaute/bug-suggestions/

Temps de chargement coté back-end: 2.675 sec

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
         270932 function calls (263488 primitive calls) in 2.675 seconds

   Ordered by: internal time, call count

   ncalls  tottime  percall  cumtime  percall filename:lineno(function)
      319    0.217    0.001    0.243    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb/cursors.py:315(_do_query)
      657    0.062    0.000    0.134    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:259(get_default_columns)
     1126    0.052    0.000    0.142    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:213(clone)
    13826    0.046    0.000    0.066    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:49(quote_name_unless_alias)
      379    0.045    0.000    0.060    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/backends/mysql/compiler.py:6(resolve_columns)
       24    0.043    0.002    0.045    0.002 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/pack.py:521(_set_cache_)
      324    0.043    0.000    0.182    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:177(get_columns)
   498/89    0.041    0.000    0.212    0.002 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:618(fill_related_selections)
      793    0.037    0.000    0.063    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/base.py:325(__init__)
  324/319    0.036    0.000    0.622    0.002 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:65(as_sql)
     1378    0.035    0.000    1.512    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:752(_resolve_lookup)
    534/1    0.035    0.000    2.497    2.497 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:836(render)
     7207    0.033    0.000    0.033    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py:294(quote_name)
     1200    0.032    0.000    0.156    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:1331(setup_joins)
     1200    0.029    0.000    0.071    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:1251(names_to_path)
      503    0.029    0.000    0.226    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:1011(build_filter)
5838/5827    0.027    0.000    0.033    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/encoding.py:84(force_text)
     6777    0.027    0.000    0.027    0.000 :8(__new__)
     1414    0.026    0.000    0.086    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/functional.py:197(wrapper)
    48/24    0.025    0.001    0.033    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/pack.py:262(_set_cache_)
      319    0.022    0.000    0.073    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb/cursors.py:324(_fetch_row)
   498/89    0.022    0.000    0.080    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/query.py:1153(get_klass_info)
     3092    0.022    0.000    0.022    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/datastructures.py:127(__init__)
     9776    0.021    0.000    0.022    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/query_utils.py:141(select_related_descend)
     1651    0.021    0.000    0.035    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:833(join)
      627    0.020    0.000    1.041    0.002 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:706(results_iter)
      627    0.020    0.000    1.244    0.002 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/query.py:160(iterator)
   2849/1    0.020    0.000    2.497    2.497 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/debug.py:76(render_node)
      324    0.019    0.000    0.028    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:509(get_from_clause)
      228    0.018    0.000    0.064    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/options.py:456(get_all_related_objects_with_model)
      348    0.018    0.000    0.029    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:105(__init__)
      512    0.018    0.000    0.027    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:1383(trim_joins)
     3300    0.018    0.000    0.024    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/options.py:471()
      476    0.017    0.000    0.083    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/where.py:166(make_atom)
     4283    0.017    0.000    0.033    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:660()

 ---- By file ----

      tottime
13.5%   0.350 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py
12.5%   0.325 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py
12.4%   0.321 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb/cursors.py
 6.5%   0.170 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py
 5.2%   0.136 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/query.py
 4.9%   0.128 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/fields/related.py
 3.3%   0.085 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/options.py
 3.0%   0.079 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/pack.py
 2.9%   0.075 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/datastructures.py
 2.5%   0.066 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/where.py
 2.3%   0.060 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/fields/__init__.py
 2.1%   0.055 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/debug.py
 2.1%   0.054 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py
 2.0%   0.052 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/base.py
 1.8%   0.046 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/functional.py
 1.7%   0.045 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/backends/mysql/compiler.py
 1.7%   0.044 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/tree.py
 1.4%   0.037 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/defaulttags.py
 1.2%   0.032 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/query_utils.py
 1.0%   0.027 
 1.0%   0.026 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/backends/__init__.py
 1.0%   0.026 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/utils.py
 1.0%   0.025 /opt/zdsenv/local/lib/python2.7/site-packages/django/core/urlresolvers.py
 0.9%   0.024 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb/connections.py
 0.7%   0.018 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/backends/util.py
 0.6%   0.016 /opt/zdsenv/ZesteDeSavoir/zds/forum/models.py
 0.6%   0.015 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb/times.py
 0.6%   0.015 /opt/zdsenv/lib/python2.7/encodings/utf_8.py
 0.5%   0.014 /opt/zdsenv/ZesteDeSavoir/zds/utils/templatetags/interventions.py
 0.5%   0.013 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/six.py
 0.5%   0.012 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/manager.py
 0.4%   0.011 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/text.py
 0.4%   0.011 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/safestring.py
 0.4%   0.011 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/context.py
 0.4%   0.011 /opt/zdsenv/lib/python2.7/re.py
 0.3%   0.009 /usr/lib/python2.7/copy.py
 0.3%   0.009 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/regex_helper.py
 0.3%   0.009 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/encoding.py
 0.3%   0.009 /opt/zdsenv/local/lib/python2.7/site-packages/django/dispatch/dispatcher.py
 0.3%   0.008 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/translation/trans_real.py

 ---- By group ---

      tottime
54.7%   1.420 /opt/zdsenv/local/lib/python2.7/site-packages/django/db
13.9%   0.362 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb
11.4%   0.295 /opt/zdsenv/local/lib/python2.7/site-packages/django/template
10.2%   0.264 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils
 3.1%   0.080 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb
 1.0%   0.027 
 1.0%   0.025 /opt/zdsenv/local/lib/python2.7/site-packages/django/core
 0.9%   0.023 /usr/lib/python2.7
 0.8%   0.022 /opt/zdsenv/lib/python2.7
 0.7%   0.019 /opt/zdsenv/ZesteDeSavoir/zds/utils/templatetags
 0.6%   0.016 /opt/zdsenv/ZesteDeSavoir/zds/forum
 0.6%   0.015 /opt/zdsenv/lib/python2.7/encodings
 0.4%   0.010 /opt/zdsenv/local/lib/python2.7/site-packages/django/dispatch
 0.3%   0.008 /opt/zdsenv/local/lib/python2.7/site-packages/django/conf
 0.1%   0.003 /opt/zdsenv/local/lib/python2.7/site-packages/django/shortcuts
 0.1%   0.002 /opt/zdsenv/local/lib/python2.7/site-packages/smmap
 0.1%   0.002 /opt/zdsenv/ZesteDeSavoir/zds/utils
 0.0%   0.001 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/db
 0.0%   0.001 /opt/zdsenv/local/lib/python2.7/site-packages/git/refs
 0.0%   0.001 /opt/zdsenv/local/lib/python2.7/site-packages/django/contrib
 0.0%   0.001 /opt/zdsenv/ZesteDeSavoir/zds
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/git/repo
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/git/objects
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/git
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/templatetags
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/middleware
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/http
 0.0%   0.000 /opt/zdsenv/ZesteDeSavoir/zds/member

Un Topic

url : http://zestedesavoir.com/forums/sujet/273/les-petits-pixels/?page=3

Temps de chargement coté back-end : 3.927 sec

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
         321337 function calls (307864 primitive calls) in 3.927 seconds

   Ordered by: internal time, call count

   ncalls  tottime  percall  cumtime  percall filename:lineno(function)
      353    0.135    0.000    0.164    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb/cursors.py:315(_do_query)
      255    0.127    0.000    0.199    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/functional.py:91(__prepare_class__)
   1165/1    0.085    0.000    3.377    3.377 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:836(render)
    21825    0.072    0.000    0.072    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/functional.py:119(__promise__)
      766    0.066    0.000    0.087    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/backends/mysql/compiler.py:6(resolve_columns)
   6290/1    0.066    0.000    3.375    3.375 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/debug.py:76(render_node)
      412    0.058    0.000    0.134    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:259(get_default_columns)
    389/6    0.057    0.000    0.375    0.063 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:241(parse)
     1098    0.055    0.000    0.164    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:213(clone)
     3117    0.054    0.000    1.101    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:752(_resolve_lookup)
     1006    0.047    0.000    0.210    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:1331(setup_joins)
      692    0.043    0.000    0.066    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/base.py:325(__init__)
     3355    0.043    0.000    2.481    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:582(resolve)
     1983    0.042    0.000    0.230    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/functional.py:197(wrapper)
10927/10707    0.042    0.000    0.064    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/encoding.py:84(force_text)
      514    0.042    0.000    0.305    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:1011(build_filter)
     8329    0.040    0.000    0.059    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:49(quote_name_unless_alias)
  358/353    0.038    0.000    0.669    0.002 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:65(as_sql)
     5882    0.037    0.000    0.037    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py:294(quote_name)
   208/60    0.036    0.000    0.135    0.002 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:618(fill_related_selections)
      358    0.033    0.000    0.185    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:177(get_columns)
     1006    0.032    0.000    0.110    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:1251(names_to_path)
      851    0.030    0.000    0.051    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/fields/related.py:1054(get_path_info)
      137    0.028    0.000    0.028    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:488(_final_join_removal)
     4129    0.028    0.000    0.028    0.000 /opt/zdsenv/lib/python2.7/encodings/utf_8.py:15(decode)
     2097    0.028    0.000    0.038    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:201(create_token)
      759    0.027    0.000    0.050    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:687(__init__)
      353    0.027    0.000    0.109    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb/cursors.py:324(_fetch_row)
     2196    0.027    0.000    0.056    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/datastructures.py:245(copy)
      346    0.027    0.000    0.086    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/fields/related.py:1071(get_lookup_constraint)
     1414    0.026    0.000    0.038    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:833(join)
     1051    0.025    0.000    1.143    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:706(results_iter)
      358    0.025    0.000    0.036    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:509(get_from_clause)
      255    0.025    0.000    0.025    0.000 /usr/lib/python2.7/functools.py:53(total_ordering)
      666    0.024    0.000    0.076    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:538(__init__)

 ---- By file ----

      tottime
11.7%   0.444 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py
11.2%   0.426 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py
 8.9%   0.336 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py
 7.8%   0.296 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/functional.py
 7.3%   0.277 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb/cursors.py
 4.0%   0.153 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/debug.py
 3.8%   0.145 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/fields/related.py
 3.5%   0.131 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/query.py
 2.5%   0.093 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/datastructures.py
 2.2%   0.082 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/where.py
 2.2%   0.082 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/options.py
 2.0%   0.077 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/fields/__init__.py
 2.0%   0.077 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/defaulttags.py
 1.8%   0.070 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py
 1.7%   0.066 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/backends/mysql/compiler.py
 1.5%   0.055 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/base.py
 1.3%   0.051 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/tree.py
 1.1%   0.042 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/utils.py
 1.1%   0.041 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/smartif.py
 0.9%   0.035 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb/connections.py
 0.9%   0.033 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/backends/__init__.py
 0.9%   0.033 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/text.py
 0.8%   0.032 /opt/zdsenv/local/lib/python2.7/site-packages/django/core/urlresolvers.py
 0.8%   0.031 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/pack.py
 0.8%   0.031 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/query_utils.py
 0.8%   0.030 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/formats.py
 0.8%   0.029 /usr/lib/python2.7/functools.py
 0.7%   0.028 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/backends/util.py
 0.7%   0.028 /opt/zdsenv/lib/python2.7/encodings/utf_8.py
 0.7%   0.027 /opt/zdsenv/local/lib/python2.7/site-packages/markdown/treeprocessors.py
 0.6%   0.022 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/html.py
 0.6%   0.021 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/safestring.py
 0.6%   0.021 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/loaders/filesystem.py
 0.6%   0.021 
 0.5%   0.020 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb/times.py
 0.5%   0.019 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/loader_tags.py
 0.5%   0.018 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/six.py
 0.5%   0.018 /opt/zdsenv/lib/python2.7/re.py
 0.4%   0.017 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/translation/__init__.py
 0.4%   0.015 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/encoding.py

 ---- By group ---

      tottime
43.4%   1.645 /opt/zdsenv/local/lib/python2.7/site-packages/django/db
20.1%   0.761 /opt/zdsenv/local/lib/python2.7/site-packages/django/template
17.4%   0.660 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils
 8.8%   0.334 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb
 1.5%   0.055 /usr/lib/python2.7
 1.5%   0.055 /opt/zdsenv/local/lib/python2.7/site-packages/markdown
 1.2%   0.046 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb
 1.1%   0.042 /opt/zdsenv/lib/python2.7
 0.9%   0.035 /opt/zdsenv/local/lib/python2.7/site-packages/django/core
 0.7%   0.028 /opt/zdsenv/lib/python2.7/encodings
 0.6%   0.021 
 0.5%   0.019 /opt/zdsenv/ZesteDeSavoir/zds/utils/templatetags
 0.4%   0.017 /opt/zdsenv/ZesteDeSavoir/zds/forum
 0.4%   0.015 /opt/zdsenv/local/lib/python2.7/site-packages/django/dispatch
 0.4%   0.014 /opt/zdsenv/local/lib/python2.7/site-packages/django/conf
 0.2%   0.009 /opt/zdsenv/local/lib/python2.7/site-packages/smmap
 0.2%   0.008 /opt/zdsenv/local/lib/python2.7/site-packages/django/contrib
 0.2%   0.006 /opt/zdsenv/local/lib/python2.7/site-packages/markdown/extensions
 0.1%   0.003 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/db
 0.1%   0.003 /opt/zdsenv/local/lib/python2.7/site-packages/django/shortcuts
 0.1%   0.002 /opt/zdsenv/local/lib/python2.7/site-packages/model_utils
 0.1%   0.002 /opt/zdsenv/local/lib/python2.7/site-packages/django/middleware
 0.1%   0.002 /opt/zdsenv/local/lib/python2.7/site-packages/django/forms
 0.1%   0.002 /opt/zdsenv/local/lib/python2.7/site-packages/crispy_forms
 0.0%   0.001 /opt/zdsenv/local/lib/python2.7/site-packages/git/refs
 0.0%   0.001 /opt/zdsenv/ZesteDeSavoir/zds/utils
 0.0%   0.001 /opt/zdsenv/ZesteDeSavoir/zds/member
 0.0%   0.001 /opt/zdsenv/ZesteDeSavoir/zds
 0.0%   0.000 /usr/lib/python2.7/xml/etree
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/git/repo
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/git/objects
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/git
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/templatetags
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/http
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/crispy_forms/templatetags

Les tutoriels

Big tuto

url : http://zestedesavoir.com/tutoriels/330/debuter-sur-adobe-photoshop/

Temps de chargement coté back-end : 5.945 sec

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
         113663 function calls (109181 primitive calls) in 5.945 seconds

   Ordered by: internal time, call count

   ncalls  tottime  percall  cumtime  percall filename:lineno(function)
     2764    0.307    0.000    0.918    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/functional.py:197(wrapper)
8052/8049    0.205    0.000    0.278    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/encoding.py:84(force_text)
       49    0.182    0.004    0.190    0.004 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb/cursors.py:315(_do_query)
     2339    0.152    0.000    0.421    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:752(_resolve_lookup)
      264    0.137    0.001    0.867    0.003 /opt/zdsenv/local/lib/python2.7/site-packages/django/core/urlresolvers.py:396(_reverse_with_prefix)
     2593    0.135    0.000    2.160    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:582(resolve)
     1598    0.129    0.000    0.136    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/debug.py:58(extend_nodelist)
     20/5    0.126    0.006    1.290    0.258 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/loader.py:133(get_template)
     3779    0.108    0.000    0.140    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/encoding.py:139(force_bytes)
    481/1    0.099    0.000    4.556    4.556 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:836(render)
      134    0.097    0.001    0.918    0.007 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/query.py:160(iterator)
      204    0.093    0.000    0.202    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:213(clone)
    358/5    0.082    0.000    1.158    0.232 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:241(parse)
      667    0.079    0.000    0.699    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/debug.py:86(render)
      543    0.078    0.000    0.093    0.000 /opt/zdsenv/lib/python2.7/re.py:144(sub)
     1417    0.070    0.000    0.350    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/http.py:33(urlquote)
    63/11    0.070    0.001    2.197    0.200 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/defaulttags.py:142(render)
      667    0.066    0.000    0.222    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/formats.py:150(localize)
     1968    0.064    0.000    0.147    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/debug.py:28(create_token)
  168/165    0.064    0.000    0.066    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:1161()
      264    0.062    0.000    0.955    0.004 /opt/zdsenv/local/lib/python2.7/site-packages/django/core/urlresolvers.py:478(reverse)
      711    0.059    0.000    0.230    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:687(__init__)
     1968    0.059    0.000    0.083    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:201(create_token)
     2395    0.058    0.000    0.058    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/context.py:51(__getitem__)
      672    0.054    0.000    0.066    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/formats.py:72(get_format)
      224    0.053    0.000    1.075    0.005 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/defaulttags.py:415(render)
       20    0.053    0.003    0.095    0.005 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/loaders/filesystem.py:33(load_template_source)
        7    0.052    0.007    0.052    0.007 /usr/lib/python2.7/json/decoder.py:371(raw_decode)
      264    0.051    0.000    0.080    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/regex_helper.py:46(normalize)
      159    0.051    0.000    0.051    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/fields/related.py:992(foreign_related_fields)
     1353    0.050    0.000    0.050    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/safestring.py:104(mark_safe)
       53    0.050    0.001    0.102    0.002 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:259(get_default_columns)
      836    0.049    0.000    0.058    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:49(quote_name_unless_alias)
     1340    0.048    0.000    0.050    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/text.py:340(smart_split)
        1    0.046    0.046    5.400    5.400 /opt/zdsenv/local/lib/python2.7/site-packages/django/shortcuts/__init__.py:16(render_to_response)

 ---- By file ----

      tottime
16.5%   0.935 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py
 6.7%   0.377 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/debug.py
 5.9%   0.335 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py
 5.6%   0.316 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/functional.py
 4.5%   0.256 /opt/zdsenv/local/lib/python2.7/site-packages/django/core/urlresolvers.py
 4.5%   0.254 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb/cursors.py
 4.1%   0.231 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/defaulttags.py
 4.0%   0.224 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/query.py
 3.9%   0.221 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py
 2.9%   0.163 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/fields/related.py
 2.5%   0.144 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/formats.py
 2.3%   0.129 /opt/zdsenv/lib/python2.7/re.py
 2.3%   0.128 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/loader.py
 2.2%   0.127 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/text.py
 2.1%   0.117 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/encoding.py
 2.0%   0.114 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/datastructures.py
 1.9%   0.107 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/where.py
 1.5%   0.087 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/safestring.py
 1.4%   0.080 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/regex_helper.py
 1.4%   0.078 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/context.py
 1.4%   0.078 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/options.py
 1.4%   0.077 /opt/zdsenv/ZesteDeSavoir/zds/tutorial/models.py
 1.2%   0.070 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/http.py
 1.2%   0.068 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/smartif.py
 1.0%   0.054 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/loaders/filesystem.py
 0.9%   0.052 /usr/lib/python2.7/json/decoder.py
 0.9%   0.051 /opt/zdsenv/lib/python2.7/posixpath.py
 0.9%   0.051 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/stream.py
 0.8%   0.047 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/six.py
 0.8%   0.046 /opt/zdsenv/local/lib/python2.7/site-packages/django/shortcuts/__init__.py
 0.8%   0.045 /usr/lib/python2.7/urllib.py
 0.8%   0.045 /opt/zdsenv/lib/python2.7/encodings/utf_8.py
 0.8%   0.044 /opt/zdsenv/local/lib/python2.7/site-packages/django/conf/__init__.py
 0.6%   0.033 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/tree.py
 0.5%   0.031 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py
 0.5%   0.028 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/utils.py
 0.5%   0.026 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/translation/trans_real.py
 0.4%   0.025 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/_os.py
 0.4%   0.024 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/util.py
 0.4%   0.023 /opt/zdsenv/local/lib/python2.7/site-packages/easy_thumbnails/conf.py

 ---- By group ---

      tottime
33.7%   1.905 /opt/zdsenv/local/lib/python2.7/site-packages/django/template
22.6%   1.279 /opt/zdsenv/local/lib/python2.7/site-packages/django/db
22.0%   1.247 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils
 4.6%   0.259 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb
 4.5%   0.256 /opt/zdsenv/local/lib/python2.7/site-packages/django/core
 3.4%   0.191 /opt/zdsenv/lib/python2.7
 1.6%   0.092 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb
 1.4%   0.079 /opt/zdsenv/ZesteDeSavoir/zds/tutorial
 1.2%   0.070 /usr/lib/python2.7
 0.9%   0.052 /usr/lib/python2.7/json
 0.8%   0.046 /opt/zdsenv/local/lib/python2.7/site-packages/django/shortcuts
 0.8%   0.045 /opt/zdsenv/lib/python2.7/encodings
 0.8%   0.044 /opt/zdsenv/local/lib/python2.7/site-packages/django/conf
 0.5%   0.028 /opt/zdsenv/local/lib/python2.7/site-packages/easy_thumbnails
 0.2%   0.014 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/db
 0.2%   0.013 /opt/zdsenv/local/lib/python2.7/site-packages/smmap
 0.2%   0.011 /opt/zdsenv/ZesteDeSavoir/zds/forum
 0.1%   0.008 /opt/zdsenv/local/lib/python2.7/site-packages/git/objects
 0.1%   0.005 
 0.1%   0.005 /opt/zdsenv/local/lib/python2.7/site-packages/django/dispatch
 0.1%   0.003 /opt/zdsenv/local/lib/python2.7/site-packages/git
 0.0%   0.002 /opt/zdsenv/ZesteDeSavoir/zds/utils/templatetags
 0.0%   0.002 /opt/zdsenv/ZesteDeSavoir/zds/utils
 0.0%   0.001 /opt/zdsenv/local/lib/python2.7/site-packages/git/repo
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/git/refs
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/templatetags
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/middleware
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/http
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/forms
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/contrib
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/crispy_forms
 0.0%   0.000 /opt/zdsenv/ZesteDeSavoir/zds/member
 0.0%   0.000 /opt/zdsenv/ZesteDeSavoir/zds

Mini tuto

url : http://zestedesavoir.com/tutoriels/229/la-3d-pour-le-jeu-video-avec-blender/

Temps de chargement coté back-end: 3.068 sec

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
         81856 function calls (78928 primitive calls) in 3.068 seconds

   Ordered by: internal time, call count

   ncalls  tottime  percall  cumtime  percall filename:lineno(function)
       49    0.139    0.003    0.143    0.003 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb/cursors.py:315(_do_query)
  182/156    0.096    0.001    0.096    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/stream.py:199(read)
     1063    0.088    0.000    0.161    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/functional.py:197(wrapper)
     1968    0.085    0.000    0.132    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:201(create_token)
    358/5    0.074    0.000    0.642    0.128 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:241(parse)
       27    0.067    0.002    0.071    0.003 /opt/zdsenv/local/lib/python2.7/site-packages/git/config.py:195(_read)
       26    0.066    0.003    0.068    0.003 /opt/zdsenv/local/lib/python2.7/site-packages/git/objects/fun.py:39(tree_entries_from_data)
       20    0.064    0.003    0.068    0.003 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/loaders/filesystem.py:33(load_template_source)
      911    0.051    0.000    0.111    0.000 /opt/zdsenv/lib/python2.7/posixpath.py:350(abspath)
    135/1    0.050    0.000    1.365    1.365 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:836(render)
     1340    0.048    0.000    0.049    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/text.py:340(smart_split)
     1968    0.045    0.000    0.047    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:156(__init__)
      711    0.045    0.000    0.107    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:687(__init__)
     1598    0.044    0.000    0.050    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/debug.py:58(extend_nodelist)
      105    0.037    0.000    0.214    0.002 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/db/base.py:227(_db_query)
      690    0.036    0.000    0.199    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:538(__init__)
      999    0.034    0.000    0.034    0.000 /opt/zdsenv/lib/python2.7/posixpath.py:321(normpath)
      106    0.033    0.000    0.056    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/util.py:181(file_contents_ro_filepath)
       20    0.030    0.001    0.180    0.009 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/debug.py:13(tokenize)
      196    0.029    0.000    0.095    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:213(clone)
      983    0.028    0.000    0.028    0.000 /opt/zdsenv/lib/python2.7/posixpath.py:59(isabs)
      836    0.028    0.000    0.030    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:49(quote_name_unless_alias)
      374    0.027    0.000    0.027    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/defaulttags.py:291()
   106/79    0.026    0.000    0.081    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/db/pack.py:54(_sort_entities)
       92    0.026    0.000    0.043    0.000 /usr/lib/python2.7/inspect.py:803(getargspec)
        1    0.025    0.025    3.068    3.068 /opt/zdsenv/ZesteDeSavoir/zds/tutorial/views.py:737(view_tutorial_online)
       80    0.025    0.000    0.026    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:1383(trim_joins)
      690    0.024    0.000    0.222    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:356(compile_filter)
      105    0.023    0.000    0.023    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/util.py:153(file_contents_ro)
       49    0.022    0.000    0.022    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb/cursors.py:75(__init__)
      401    0.022    0.000    0.032    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/tree.py:29(_new_instance)
       55    0.022    0.000    0.030    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:105(__init__)
     1683    0.022    0.000    0.022    0.000 /opt/zdsenv/lib/python2.7/posixpath.py:68(join)
       53    0.021    0.000    0.056    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:259(get_default_columns)
      531    0.020    0.000    0.020    0.000 :8(__new__)

 ---- By file ----

      tottime
14.9%   0.447 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py
 6.3%   0.190 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb/cursors.py
 6.2%   0.186 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py
 4.5%   0.136 /opt/zdsenv/lib/python2.7/posixpath.py
 4.4%   0.133 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/stream.py
 3.9%   0.118 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/functional.py
 3.9%   0.116 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py
 3.6%   0.107 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/debug.py
 3.1%   0.093 /opt/zdsenv/local/lib/python2.7/site-packages/git/config.py
 2.5%   0.074 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/text.py
 2.4%   0.073 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/util.py
 2.3%   0.070 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/db/pack.py
 2.2%   0.066 /opt/zdsenv/local/lib/python2.7/site-packages/git/objects/fun.py
 2.2%   0.065 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/loaders/filesystem.py
 1.9%   0.058 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/defaulttags.py
 1.8%   0.053 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/where.py
 1.5%   0.046 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/db/base.py
 1.5%   0.045 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/query.py
 1.5%   0.045 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/tree.py
 1.5%   0.044 /opt/zdsenv/lib/python2.7/genericpath.py
 1.3%   0.039 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/fields/related.py
 1.3%   0.039 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/db/loose.py
 1.2%   0.035 /opt/zdsenv/ZesteDeSavoir/zds/tutorial/models.py
 1.1%   0.033 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/datastructures.py
 1.0%   0.031 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/options.py
 1.0%   0.029 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/base.py
 0.9%   0.028 /usr/lib/python2.7/inspect.py
 0.8%   0.025 /opt/zdsenv/ZesteDeSavoir/zds/tutorial/views.py
 0.7%   0.022 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/pack.py
 0.7%   0.020 
 0.6%   0.019 /usr/lib/python2.7/glob.py
 0.6%   0.019 /opt/zdsenv/local/lib/python2.7/site-packages/git/objects/base.py
 0.6%   0.019 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py
 0.6%   0.019 /opt/zdsenv/lib/python2.7/re.py
 0.6%   0.019 /opt/zdsenv/ZesteDeSavoir/zds/utils/tutorials.py
 0.6%   0.017 /opt/zdsenv/local/lib/python2.7/site-packages/git/objects/tree.py
 0.6%   0.017 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/smartif.py
 0.6%   0.017 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb/connections.py
 0.5%   0.016 /opt/zdsenv/local/lib/python2.7/site-packages/git/repo/base.py
 0.5%   0.015 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/fields/__init__.py

 ---- By group ---

      tottime
23.9%   0.720 /opt/zdsenv/local/lib/python2.7/site-packages/django/template
19.2%   0.578 /opt/zdsenv/local/lib/python2.7/site-packages/django/db
11.3%   0.339 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils
 8.9%   0.267 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb
 7.8%   0.236 /opt/zdsenv/lib/python2.7
 6.9%   0.208 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb
 5.2%   0.157 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/db
 3.9%   0.117 /opt/zdsenv/local/lib/python2.7/site-packages/git/objects
 3.6%   0.109 /opt/zdsenv/local/lib/python2.7/site-packages/git
 2.5%   0.074 /usr/lib/python2.7
 2.0%   0.060 /opt/zdsenv/ZesteDeSavoir/zds/tutorial
 0.7%   0.022 /opt/zdsenv/local/lib/python2.7/site-packages/git/repo
 0.7%   0.022 /opt/zdsenv/ZesteDeSavoir/zds/utils
 0.7%   0.020 
 0.6%   0.018 /opt/zdsenv/local/lib/python2.7/site-packages/django/core
 0.5%   0.016 /opt/zdsenv/ZesteDeSavoir/zds/utils/templatetags
 0.4%   0.011 /opt/zdsenv/local/lib/python2.7/site-packages/django/shortcuts
 0.3%   0.009 /usr/lib/python2.7/json
 0.3%   0.009 /opt/zdsenv/lib/python2.7/encodings
 0.1%   0.004 /opt/zdsenv/local/lib/python2.7/site-packages/smmap
 0.1%   0.003 /opt/zdsenv/local/lib/python2.7/site-packages/django/conf
 0.1%   0.003 /opt/zdsenv/ZesteDeSavoir/zds/forum
 0.1%   0.002 /opt/zdsenv/local/lib/python2.7/site-packages/django/dispatch
 0.0%   0.001 /opt/zdsenv/local/lib/python2.7/site-packages/git/refs
 0.0%   0.001 /opt/zdsenv/local/lib/python2.7/site-packages/easy_thumbnails
 0.0%   0.001 /opt/zdsenv/local/lib/python2.7/site-packages/crispy_forms
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/templatetags
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/middleware
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/http
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/forms
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/contrib
 0.0%   0.000 /opt/zdsenv/ZesteDeSavoir/zds/member
 0.0%   0.000 /opt/zdsenv/ZesteDeSavoir/zds

Les articles

url : http://zestedesavoir.com/articles/57/ouverture-officielle-de-zeste-de-savoir/

Temps de chargement coté back-end : 2.458 sec

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
         205968 function calls (196269 primitive calls) in 2.458 seconds

   Ordered by: internal time, call count

   ncalls  tottime  percall  cumtime  percall filename:lineno(function)
      244    0.154    0.001    0.171    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb/cursors.py:315(_do_query)
      214    0.099    0.000    0.158    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/functional.py:91(__prepare_class__)
    18392    0.060    0.000    0.060    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/functional.py:119(__promise__)
    917/1    0.058    0.000    2.039    2.039 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:836(render)
     2469    0.046    0.000    0.274    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:752(_resolve_lookup)
      698    0.042    0.000    0.104    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:213(clone)
     1528    0.036    0.000    0.175    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/functional.py:197(wrapper)
   5194/1    0.035    0.000    2.038    2.038 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/debug.py:76(render_node)
      204    0.033    0.000    0.065    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:259(get_default_columns)
8669/8582    0.032    0.000    0.041    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/encoding.py:84(force_text)
    282/4    0.030    0.000    0.244    0.061 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:241(parse)
     1584    0.029    0.000    0.053    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/debug.py:28(create_token)
     2715    0.028    0.000    1.372    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:582(resolve)
      568    0.024    0.000    0.055    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:687(__init__)
      779    0.022    0.000    0.406    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/debug.py:86(render)
  249/244    0.022    0.000    0.256    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:65(as_sql)
      310    0.021    0.000    0.162    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:1011(build_filter)
     1982    0.021    0.000    0.021    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/safestring.py:104(mark_safe)
      214    0.020    0.000    0.020    0.000 /usr/lib/python2.7/functools.py:53(total_ordering)
       24    0.018    0.001    0.021    0.001 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/pack.py:364(_read_fanout)
      506    0.018    0.000    0.081    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:538(__init__)
       16    0.018    0.001    0.071    0.004 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/debug.py:13(tokenize)
     1945    0.017    0.000    0.017    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/datastructures.py:127(__init__)
     3634    0.017    0.000    0.025    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py:49(quote_name_unless_alias)
      331    0.017    0.000    0.022    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/backends/mysql/compiler.py:6(resolve_columns)
      214    0.016    0.000    0.044    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/functional.py:62(lazy)
      249    0.016    0.000    0.029    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:105(__init__)
     3121    0.016    0.000    0.016    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py:294(quote_name)
     2517    0.016    0.000    0.016    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/context.py:51(__getitem__)
      306    0.015    0.000    0.072    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/where.py:166(make_atom)
     2643    0.015    0.000    0.288    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:731(resolve)
      199    0.015    0.000    0.073    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/core/urlresolvers.py:396(_reverse_with_prefix)
  619/308    0.014    0.000    0.021    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py:1152(need_having)
     3000    0.014    0.000    0.014    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/tree.py:18(__init__)
     1584    0.014    0.000    0.023    0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py:201(create_token)

 ---- By file ----

      tottime
12.9%   0.304 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/base.py
 9.9%   0.234 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/functional.py
 9.7%   0.228 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/query.py
 9.4%   0.222 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb/cursors.py
 6.3%   0.148 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py
 5.2%   0.123 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/debug.py
 3.1%   0.072 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/query.py
 2.8%   0.067 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/fields/related.py
 2.6%   0.062 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/defaulttags.py
 2.4%   0.056 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/sql/where.py
 2.1%   0.049 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/datastructures.py
 1.5%   0.035 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py
 1.4%   0.034 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/fields/__init__.py
 1.4%   0.033 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/tree.py
 1.3%   0.030 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/pack.py
 1.1%   0.026 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/formats.py
 1.1%   0.026 /opt/zdsenv/local/lib/python2.7/site-packages/django/core/urlresolvers.py
 1.0%   0.023 /usr/lib/python2.7/functools.py
 0.9%   0.022 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/context.py
 0.9%   0.022 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/safestring.py
 0.9%   0.022 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/base.py
 0.9%   0.021 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/smartif.py
 0.9%   0.021 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/backends/__init__.py
 0.8%   0.019 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/options.py
 0.8%   0.019 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/utils.py
 0.8%   0.019 /opt/zdsenv/lib/python2.7/re.py
 0.8%   0.018 /opt/zdsenv/local/lib/python2.7/site-packages/markdown/treeprocessors.py
 0.8%   0.018 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/text.py
 0.8%   0.018 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/six.py
 0.7%   0.017 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/regex_helper.py
 0.7%   0.017 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/backends/mysql/compiler.py
 0.7%   0.016 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb/connections.py
 0.6%   0.015 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/translation/__init__.py
 0.6%   0.014 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/backends/util.py
 0.6%   0.014 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/html.py
 0.5%   0.011 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils/encoding.py
 0.5%   0.011 /opt/zdsenv/lib/python2.7/encodings/utf_8.py
 0.4%   0.010 /opt/zdsenv/local/lib/python2.7/site-packages/django/db/models/manager.py
 0.4%   0.010 /opt/zdsenv/local/lib/python2.7/site-packages/django/conf/__init__.py
 0.4%   0.010 /opt/zdsenv/local/lib/python2.7/site-packages/django/template/loaders/filesystem.py

 ---- By group ---

      tottime
32.9%   0.776 /opt/zdsenv/local/lib/python2.7/site-packages/django/db
23.5%   0.555 /opt/zdsenv/local/lib/python2.7/site-packages/django/template
21.1%   0.497 /opt/zdsenv/local/lib/python2.7/site-packages/django/utils
10.3%   0.244 /opt/zdsenv/local/lib/python2.7/site-packages/MySQLdb
 1.9%   0.045 /usr/lib/python2.7
 1.7%   0.039 /opt/zdsenv/local/lib/python2.7/site-packages/markdown
 1.7%   0.039 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb
 1.6%   0.037 /opt/zdsenv/lib/python2.7
 1.2%   0.029 /opt/zdsenv/local/lib/python2.7/site-packages/django/core
 0.6%   0.014 /opt/zdsenv/ZesteDeSavoir/zds/utils/templatetags
 0.5%   0.011 /opt/zdsenv/local/lib/python2.7/site-packages/smmap
 0.5%   0.011 /opt/zdsenv/lib/python2.7/encodings
 0.4%   0.010 /opt/zdsenv/local/lib/python2.7/site-packages/django/conf
 0.3%   0.007 /opt/zdsenv/local/lib/python2.7/site-packages/django/contrib
 0.3%   0.006 
 0.3%   0.006 /opt/zdsenv/local/lib/python2.7/site-packages/git
 0.3%   0.006 /opt/zdsenv/local/lib/python2.7/site-packages/easy_thumbnails
 0.3%   0.006 /opt/zdsenv/ZesteDeSavoir/zds/article
 0.2%   0.005 /opt/zdsenv/local/lib/python2.7/site-packages/django/shortcuts
 0.2%   0.004 /opt/zdsenv/local/lib/python2.7/site-packages/markdown/extensions
 0.1%   0.003 /opt/zdsenv/local/lib/python2.7/site-packages/model_utils
 0.1%   0.003 /opt/zdsenv/local/lib/python2.7/site-packages/django/dispatch
 0.1%   0.002 /opt/zdsenv/ZesteDeSavoir/zds/utils
 0.0%   0.001 /usr/lib/python2.7/json
 0.0%   0.001 /opt/zdsenv/local/lib/python2.7/site-packages/django/middleware
 0.0%   0.001 /opt/zdsenv/ZesteDeSavoir/zds/member
 0.0%   0.001 /opt/zdsenv/ZesteDeSavoir/zds
 0.0%   0.000 /usr/lib/python2.7/xml/etree
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/gitdb/db
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/git/repo
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/git/refs
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/git/objects
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/templatetags
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/http
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/django/forms
 0.0%   0.000 /opt/zdsenv/local/lib/python2.7/site-packages/crispy_forms
 0.0%   0.000 /opt/zdsenv/ZesteDeSavoir/zds/forum

Notons aussi que l'article profilé est a 48 commentaires au moment ou j'écris ces lignes


Voila un début de profiling tout de même, l'idée est surtout d'avoir les chiffres pour trouver ensemble comment mieux optimiser.

Édité par firm1

Du coup si j'ai bien compris l'explication du mec la granularité la plus fine c'est fonction par fonction ? (un profiling par appel de méthode).

Si c'est le cas c'est réellement chouette, le jour où il y a un soucis de perf sur une page en particulier ça permettra d'avoir une meilleure idée du coupable.

J'ai déjà fait ce genre de trucs avec Spring AOP mais ma faible connaissance en Python m'empêche de bien piger le fonctionnement. Est-ce-que tu pourrais nous en dire plus (peut-être pas sur ce topic) ?

Happiness is a warm puppy

+0 -0
Staff
Auteur du sujet

Du coup si j'ai bien compris l'explication du mec la granularité la plus fine c'est fonction par fonction ?

artragis

Oui, tu as bien compris. Et ça se fait sur les fonction uniquement coté python. En gros, sur un site comme celui de ZdS, on utilise pas mal des fonction liée à la base de donnée, et elle passe donc tout pas une seule fonction centrale "query.py". Le but étant que si une fonction est très souvent sollicitée, elle doit s'executer le plus rapidement possible. Quand on voit que la fonction base.py mets du temps (~2sec par moment) à s’exécuter dans les tutoriels, on peut se poser tout de suite des questions sur l'optimisation des templates.

Ici ça signifie que dans l'affichage des tutoriel, il doit y avoir une boucle trop consommatrice à éliminer.

Pour les forums, il n'ya pas de secret, il faut réduire le nombre de requêtes au maximum, c'est à dire, utiliser des jointures quand c'est utile, et pour celà, s'aider de django debug toolbar.

La page d'acceuil quant a elle est un modèle d'optimisation. On voit bien que la barre du haut (mp, notification) est optimisée a fond et on s'en sort avec un temps plutôt honorable si on considère qu'on a pas encore mis de cache quelque part sur le site.

Staff
Auteur du sujet

Allez un autre Jet : Version : v1.0-RC7/f48ae34

La page d'acceuil

url : http://zestedesavoir.com/

Temps de chargement coté back-end : 0.790 sec

Les forums

Liste des forums

url : http://zestedesavoir.com/forums/

Temps de chargement coté back-end : 2.252 sec

Liste des topics

url : http://zestedesavoir.com/forums/communaute/bug-suggestions/

Temps de chargement coté back-end: 2.174 sec

Un Topic

url : http://zestedesavoir.com/forums/sujet/273/les-petits-pixels/?page=3

Temps de chargement coté back-end : 2.895 sec

Les tutoriels

Big tuto

url : http://zestedesavoir.com/tutoriels/330/debuter-sur-adobe-photoshop/

Temps de chargement coté back-end : 0.916 sec

Mini tuto

url : http://zestedesavoir.com/tutoriels/229/la-3d-pour-le-jeu-video-avec-blender/

Temps de chargement coté back-end: 0.771 sec

Les articles

url : http://zestedesavoir.com/articles/57/ouverture-officielle-de-zeste-de-savoir/

Temps de chargement coté back-end : 1.730 sec


Ces observations ont été faites le 04 aout à 17h 30

Notons tout de même une amélioration dans les tutos/articles. Je pense que les précédents mauvais résultats était dus surtout aux problèmes de lecture disques sur le serveur.

Staff
Auteur du sujet

Encore un autre Jet : Version : v1.0b/9dc0e98

La page d'acceuil

url : http://zestedesavoir.com/

Temps de chargement coté back-end : 0.703 sec

Les forums

Liste des forums

url : http://zestedesavoir.com/forums/

Temps de chargement coté back-end : 2.495 sec

Liste des topics

url : http://zestedesavoir.com/forums/communaute/bug-suggestions/

Temps de chargement coté back-end: 2.400 sec

Un Topic

url : http://zestedesavoir.com/forums/sujet/273/les-petits-pixels/?page=3

Temps de chargement coté back-end : 2.746 sec

Les tutoriels

Big tuto

url : http://zestedesavoir.com/tutoriels/330/debuter-sur-adobe-photoshop/

Temps de chargement coté back-end : 0.916 sec

Mini tuto

url : http://zestedesavoir.com/tutoriels/229/la-3d-pour-le-jeu-video-avec-blender/

Temps de chargement coté back-end: 1.088 sec

Les articles

url : http://zestedesavoir.com/articles/57/ouverture-officielle-de-zeste-de-savoir/

Temps de chargement coté back-end : 1.816 sec

PS : ces stats on été réalisés à 16h 45

On remarque donc tout de même une légère perte de performance, mais rien de très alarmant.

J'ai l'impression qu'on a perdu en réactivité du site récemment, je me trompe ? (j'ouvre en général plusieurs onglets a la fois et je trouve qu'ils mettent plus de temps a charger qu'avant). C'est pas dramatique en soi (toujours rapide) mais faudrait voir a ce que ça s'allonge pas de plus en plus non plus si mes doutes sont confirmés…

(même l'enregistrement des messages est plus long qu'avant)

Je viens de faire un test sur la preprod, je sais pas si la config matérielle est différente mais c'est sur c'est plus rapide… (mais on est surement moins de monde a y être en même temps…)

Édité par Eskimon

ZdS, le best du Zeste ! Tuto Arduino, blog, etc

+0 -0
Staff
Auteur du sujet

Profiling à 14h 30.

La page d'acceuil

url : http://zestedesavoir.com/

Temps de chargement coté back-end : 3.057 sec

Les forums

Liste des forums

url : http://zestedesavoir.com/forums/

Temps de chargement coté back-end : 16.149 sec

Liste des topics

url : http://zestedesavoir.com/forums/communaute/bug-suggestions/

Temps de chargement coté back-end: 14.089 sec


On a clairement un problème d'infrastructure

heu… ils delirent pas un peu tes chiffres ? J'ai certes du lag mais j'ai moins de 5 secondes quand meme… Donc ta quinzaine de secondes c'est louche…

Ou alors c'est le cache de mon navigo qui optimise ?

Au passage SOS INFRA on a des erreurs Deadlock found when trying to get lock de la BDD qui popup cet après midi c’était encore jamais arrivé…

Édité par Eskimon

ZdS, le best du Zeste ! Tuto Arduino, blog, etc

+0 -0
Staff

Alors, depuis 12h30 on a les temps de réponse de la BDD qui atteignent la stratosphère. Tous les autres chiffres sont soit normaux, soit une conséquence directe de ça :

  • Load average élevé sans aucune consommation CPU (les process attendent quelque chose)
  • Sémaphores de BDD élevés (conséquence des latences) –> cause les deadlocks
  • Charge Nginx normale
  • Réseau normal
  • CPU et mémoire normaux (un peu d'I/O mais rien de grave et logique si on remarque que l'accès à la BDD déconne)
  • On ne se fait même pas voler le cache disque comme ça arrive

Analyse en première approche : les VPS sur lesquels l'hébergeur se permet de faire n'importe quoi avec les réglages et les machines physiques, c'est cool parce que c'est pas cher, mais c'est vraiment de la merde.

Il est plus que temps qu'on passe à quelque chose de plus fiable.

Pour l'heure, on ne peut absolument rien faire. Les disques sur lesquels sont la BDD mettent 1 seconde à réagir, c'est tout, on a pas la main dessus.

PS @firm1 : tes chiffres c'est un constat, pas un profiling.

Édité par firm1

Staff

Ça n'a rien à voir avec le cache, et il n'améliorerait les performances qu'à la marge dans le cas de notre problème.

Le problème ici c'est qu'on a aucune maîtrise sur rien du tout. Ici les disques durs ne réagissent plus correctement. Je n'en ai pas la preuve parce que le système ne permet même pas de vérifier ça directement ; mais ce ne serait pas la première fois et ça cadrerait avec le fait que seule la BDD se met à ramer.

Pour info, aujourd'hui et à moyen terme on a besoin de 2 cœurs à cette puissance et 3 Go de RAM (peut-être que 2 suffiraient mais on a aucune marge de manœuvre dans ce cas).

Aujourd'hui on est chez OVH sur un VPS Classic 3 à 8 €HT/mois.

Si on reste chez OVH, on peut tenter les "VPS Cloud", qui sont des serveurs virtuels mais avec une vraie technologie de virtualisation : https://www.ovh.com/fr/vps/vps-cloud.xml.

  • VPS Cloud 1 à 10 €HT/mois –> peut suffire mais juste
  • On peut tenter VPS Cloud 2 mais ça coûte 2x plus qu'aujourd'hui (16 €HT/mois)

Pour le prix d'un VPS Cloud 2 on a aussi :

  • Un Kimsufi KS3 (Core i3, 2 coeurs, 4 threads, indice de perf de 1005/thread) / 8 Go de RAM / 1 To de disque dur mais sans tolérance de pannes
  • Une DEDIBOX® XC 2014 (Intel® C2750 (Avoton), 8 coeurs / 8 threads mais en Atom, indice de perf de 491/thread) / 8 Go de RAM / 1 To de disque dur mais sans tolérance de pannes. On pourrait mettre un ESX là-dessus mais le seul disque dur risque de faire goulet d'étranglement très vite.
  • Sans doute plein d'autres trucs auxquels j'ai pas pensés

PS : serveur virtuel ou physique ? (en ce qui nous concerne)

  • Virtuel : Plus fiable (panne matérielle -> migration sur un autre serveur physique, disques durs = SAN avec tolérance de panne, etc). Matériel souvent puissant (cœurs performants, cache disque efficaces). Accès à de petites puissances. Par contre on est pas indépendant : on avait le cas au début (i/o disque aléatoires et steal sur le CPU), on a été migré et ça va mieux sauf par à-coups. D'autre part, les dimensionnements CPU / RAM / Disque sont souvent bizarres.
  • Physique : On est totalement indépendants et on a la pleine maîtrise. Moins de souplesse dans les petites puissances, mais à puissance égale c'est moins cher (et c'est plus puissant à prix égal, si on trouve une offre de même prix). Par contre la moindre erreur matérielle –> c'est 100% dans notre gueule (pas ou peu de tolérance de pannes, sauf à monter très fort en gamme).

Édité par SpaceFox

En plus de se décider rapidement, il faudrait savoir combien de temps peut prendre la migration.

Je m'explique, mi-novembre on va devoir renouveler le VPS, on ne fera donc pas un renouvellement pour 1 an, mais pour combien de temps ? 1 mois ? 3 mois ? 6 mois ?

+1 -0
Staff
Auteur du sujet

Je suis aussi de l'avis de SpaceFox en ce qui concerne le fait d'envisager une migration de serveur. Par contre avant de faire ça il faudrait une vraie étude du marché avec avantages et tarifications. Et surtout prendre en compte le fait qu'il nous faut un vrai backup.

Avec le tableau comparatif entre les mains il n'y aura plus qu'a décider en AG (ordinaire ou extraordinaire) ce qu'il faut faire.

Staff
Auteur du sujet

Et surtout prendre en compte le fait qu'il nous faut un vrai backup.

Qu'entends-tu exactement par là ?

SpaceFox

ça peut nous revenir moins chère de prendre une offre groupée Hebergement + Backup chez le même fournisseur plutôt que de prendre les deux séparément.

Vous devez être connecté pour pouvoir poster un message.
Connexion

Pas encore inscrit ?

Créez un compte en une minute pour profiter pleinement de toutes les fonctionnalités de Zeste de Savoir. Ici, tout est gratuit et sans publicité.
Créer un compte