There is the same problem in my application. It takes >8 sec to load a page.
The ACL authentication sql will take > 17 ms.

2009/3/16 WyriHaximus <[email protected]>

>
> Just curious how did you create that report?
>
> On Mar 16, 4:49 am, namsouth <[email protected]> wrote:
> > Miles,
> >    Thank for you advice, as your advice, I have been installed the
> > debug tools, try to find out which process cause the generate time is
> > so slow,
> > but I just cannot identify which module cause this problem ,   since
> > from the timer session time used in render the element is so little,
> > can you give me an suggestion which part of the report I need to focus
> > on ?
> >    really thanks for your advice.
> >
> >  * cakePHP
> >     * Session
> >       Session
> >           o Config
> >                 + userAgent
> >                 + time1237714705
> >                 + rand731973688
> >                 + timeout10
> >           o targeturlproducts_cats/showDetail/1
> >     * Request
> >       Request
> >       Cake Params
> >           o pass
> >                 + 01
> >           o named(empty)
> >           o controllerproducts_cats
> >           o actionshowDetail
> >           o plugin(null)
> >           o form(empty)
> >           o url
> >                 + urlproducts_cats/showDetail/1
> >           o isAjax(false)
> >       $_GET
> >           o urlproducts_cats/showDetail/1
> >       Cookie
> >
> >       To view Cookies, add CookieComponent to Controller
> >       Current Route
> >           o 0/:controller/:action/*
> >           o 1#^(?:/([^\/]+))?(?:/([^\/]+))?(?:/(.*))?[\/]*$#
> >           o 2
> >                 + 0controller
> >                 + 1action
> >           o 3
> >                 + plugin(null)
> >                 + controller(null)
> >                 + actionindex
> >           o 4(empty)
> >     * Sql Log
> >       Sql Logs
> >       default
> >       (default) 0 query took ms Nr      Query   Error   Affected
>  Num. rows       Took
> > (ms)
> >     * Timer
> >       Timers
> >
> >       Total Request Time: 5.431110 (seconds)
> >       Message   time in seconds
> >       Component initialization and startup      0.151990
> >       Controller Action         0.252230
> >       Render Controller Action  0.236420
> >       Rendering View    0.133010
> >       Rendering APP\views\products_cats\show_detail.ctp         0.129450
> >       Rendering APP\views\elements\main_header.ctp      0.016530
> >       Rendering APP\views\elements\navigation.ctp       0.010920
> >       Rendering APP\views\elements\breadcrumb.ctp       0.001250
> >       Rendering APP\views\elements\section_header.ctp   0.002200
> >       Rendering APP\views\elements\left_col.ctp         0.001660
> >       Rendering APP\views\elements\right_col_detail_product.ctp
> > 0.002130
> >       Rendering APP\views\elements\footer.ctp   0.000450
> >       Rendering APP\views\layouts\blank.ctp     0.001770
> >     * Log
> >       Logs
> >       error.log
> >       Time      Message
> >       2009-04-12 09:15:46       Warning: Warning (2):
> unlink(E:\AppServ\www
> > \project\workspace\jkchem\app\tmp\cache\persistent
> > \cake_core_core_paths) [function.unlink]: Permission denied in [CORE
> > \cake\libs\file.php, line 279]
> >       2009-04-12 09:15:46       Warning: Warning (2):
> unlink(E:\AppServ\www
> > \project\workspace\jkchem\app\tmp\cache\persistent
> > \cake_core_core_paths) [function.unlink]: Permission denied in [CORE
> > \cake\libs\file.php, line 279]
> >       2009-04-12 09:24:12       Warning: Warning (2):
> unlink(E:\AppServ\www
> > \project\workspace\jkchem\app\tmp\cache\models
> > \cake_model_default_jk_chem_list) [function.unlink]: Permission denied
> > in [CORE\cake\libs\file.php, line 279]
> >       2009-04-12 09:24:12       Warning: Warning (2):
> unlink(E:\AppServ\www
> > \project\workspace\jkchem\app\tmp\cache\models
> > \cake_model_default_jk_chem_list) [function.unlink]: Permission denied
> > in [CORE\cake\libs\file.php, line 279]
> >       2009-04-12 09:25:07       Warning: Warning (2):
> unlink(E:\AppServ\www
> > \project\workspace\jkchem\app\tmp\cache\persistent
> > \cake_core_core_paths) [function.unlink]: Permission denied in [CORE
> > \cake\libs\file.php, line 279]
> >       debug.log
> >       Time      Message
> >       2009-04-12 09:25:16       Debug: Notice (8): Undefined variable:
> > title in [APP\views\elements\breadcrumb.ctp, line 27]
> >       2009-04-12 09:25:17       Debug: Notice (8): Undefined variable:
> > title in [APP\views\elements\breadcrumb.ctp, line 27]
> >       2009-04-12 09:25:17       Debug: Notice (8): Undefined variable:
> > title in [APP\views\elements\breadcrumb.ctp, line 27]
> >       2009-04-12 09:25:24       Debug: Notice (8): Undefined variable:
> > title in [APP\views\elements\breadcrumb.ctp, line 27]
> >       2009-04-12 09:25:25       Debug: Notice (8): Undefined variable:
> > title in [APP\views\elements\breadcrumb.ctp, line 27]
> >       2009-04-12 09:25:26       Debug: Notice (8): Undefined variable:
> > title in [APP\views\elements\breadcrumb.ctp, line 27]
> >       2009-04-12 09:25:26       Debug: Notice (8): Undefined variable:
> > title in [APP\views\elements\breadcrumb.ctp, line 27]
> >       2009-03-16 03:38:23       Debug: Notice (8): Undefined variable:
> > title in [APP\views\elements\breadcrumb.ctp, line 27]
> >     * Memory
> >       Memory
> >
> >       Current Memory Use 6.93 MB
> >
> >       Peak Memory Use 6.95 MB
> >     * Variables
> >       View Variables
> >           o slist
> >                 + 0
> >                       # ProductsCat
> >                             * id1
> >                             * sort2
> >                             * titleNew 21st Century Chemistry 1A - 8
> >                             * icon(null)
> >                             * display1
> >                             * description
> >
> >                               Chem related issue display
> >                             * created2008-12-22 11:54:57
> >                             * modified2009-03-02 15:50:12
> >                 + 1
> >                       # ProductsCat
> >                             * id2
> >                             * sort5
> >                             * title21 Combined Science (Chem part)
> >                             * icon(null)
> >                             * display1
> >                             * description
> >
> >                               21 Combined Science (Chem part) -
> >                             * created2008-12-22 11:56:34
> >                             * modified2009-03-02 15:50:20
> >                 + 2
> >                       # ProductsCat
> >                             * id3
> >                             * sort3
> >                             * title21st Century Combined Science
> > (Chemistry Part) 1A - 3B
> >                             * icon(null)
> >                             * display1
> >                             * description
> >
> >                               Reference Books for everyone love chem
> >                             * created2008-12-22 11:57:09
> >                             * modified2009-03-02 15:50:34
> >           o cat_detail
> >                 + ProductsCat
> >                       # id1
> >                       # sort2
> >                       # titleNew 21st Century Chemistry 1A - 8
> >                       # icon(null)
> >                       # display1
> >                       # description
> >
> >                         Chem related issue display
> >                       # created2008-12-22 11:54:57
> >                       # modified2009-03-02 15:50:12
> >           o ilist
> >                 + 0
> >                       # Product
> >                             * id8
> >                             * sort0
> >                             * img1231208629.jpg
> >                             * display1
> >                             * titleBook sample1
> >                             * itemBooks
> >                             * authorHKS
> >                             * lvl(null)
> >                             * description
> >
> >                               化學是一門研究物質的性質、組成、結構、變化,以及物質間相互作用關係的科學。「化學」
> > 一詞,若單從字面解釋就是「變化的科學」之意。化學如同物理皆為自然科學之基礎科學。很多人稱化學為「中心科學」(Central science),
> > 因為化學為部分科學學門的核心,例如材料科學、奈米科技、生物化學。
> >                             * cat_id1
> >                             * created2009-01-06 10:23:51
> >                             * modified2009-01-06 10:23:49
> >                       # ProductsCat
> >                             * id1
> >                             * sort2
> >                             * titleNew 21st Century Chemistry 1A - 8
> >                             * icon(null)
> >                             * display1
> >                             * description
> >
> >                               Chem related issue display
> >                             * created2008-12-22 11:54:57
> >                             * modified2009-03-02 15:50:12
> >                 + 1
> >                       # Product
> >                             * id9
> >                             * sort1
> >                             * img1231208705.jpg
> >                             * display1
> >                             * titleSample2
> >                             * itemBooks
> >                             * authorHKS
> >                             * lvl(null)
> >                             * description
> >
> >                               化學研究的對象涉及物質之間的相互關係,或物質和能量之間的關聯。傳統的化學常常都是關
> > 於兩種物質接觸、變化,即「化學反應」,又或者是一種物質變成另一種物質的過程。這些變化有時會需要使用電磁波,當中電磁波負責激發化學作用。不過有時
> > 化學都不一定要關於物質之間的反應。光譜學研究物質與光之間的關係,而這些關係並不涉及化學反應。
> >                             * cat_id1
> >                             * created2009-01-06 10:25:07
> >                             * modified2009-01-06 10:25:05
> >                       # ProductsCat
> >                             * id1
> >                             * sort2
> >                             * titleNew 21st Century Chemistry 1A - 8
> >                             * icon(null)
> >                             * display1
> >                             * description
> >
> >                               Chem related issue display
> >                             * created2008-12-22 11:54:57
> >                             * modified2009-03-02 15:50:12
> >                 + 2
> >                       # Product
> >                             * id10
> >                             * sort0
> > ...
> >
> > read more >>
> >
>


-- 
Thanks
Joshua

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to