hi, all, I found that the problem again.
1) I ran my application with DBIC_TRACE=1 ie "DBIC_TRACE=1 myapp_server.pl -d " 2) When I clicked on a link which shows me all the subscription listings belonging to an agent, the application loads the page just fine (and quickly) 3) I then moved on to click a link within the page which shows the details of a given listing. 4 ) Application stalls What I have done: - Opened up new terminal - Ran "top" - Observed that my server process is taking up 60% of the CPU - load average is 1.31, 1.00, 0.81 - Here's what the catalyst debug screen looks like: ---------------------------------+--------------------------------------' You can connect to your server at http://lginsurance.com.au.hosting24.com.au:3000 SELECT me.id, me.user_id, me.subscriptions_id, me.name, me.rea_agent_code, me.domain_agent_code, me.logo_file, me.logo_url, me.active_from, me.active_to, me.comments, me.created_by, me.updated_by, me.created_on, me.updated_on, subscription.id, subscription.type, subscription.name, subscription.price, subscription.currency, subscription.property_type_access, subscription.comments, subscription.created_by, subscription.updated_by, subscription.created_on, subscription.updated_on FROM user_subscriptions me JOIN subscriptions subscription ON subscription.id = me.subscriptions_id WHERE ( user_id = ? ): 'test_agent' SELECT COUNT( * ) FROM user_subscriptions me JOIN subscriptions subscription ON subscription.id = me.subscriptions_id WHERE ( user_id = ? ): 'test_agent' [debug] "GET" request for "users/subscriptions/" from "123.243.50.59" [debug] Found sessionid "b061fb50b6799c8e1deb11ecd8f5011b6fc99244" in cookie [debug] Restored session "b061fb50b6799c8e1deb11ecd8f5011b6fc99244" [debug] Path is "users/subscriptions" [debug] Root.pm -> Begin [debug] Root.pm -> auto and path is users/subscriptions/ [debug] Rendering template "agents/subscriptions/list.tt2" [debug] Applying HTML page layout wrappers to agents/subscriptions/list.tt2 Any ideas? I suspected postgres to be the culprit but it's not taking any percentage of load on the CPU (from reference to 'top'). _______________________________________________ List: Catalyst@lists.scsys.co.uk Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/ Dev site: http://dev.catalyst.perl.org/