[Openinteract-help] server load - help!

[Chris M. <Chr...@te...>]

Hello,

I have a particular action within a package I wrote that tends to drive
server load up (quite a bit) every time it is run.  Just wondering about the
best way to determine what exactly is going on.  I have DEBUG => 5 in all my
queries, but I don't see anything out of the ordinary.

Note that I am using iterators wherever possible and also that the ping_log
table referenced below has > 70000 records.

This is the log of a single run of the procedure - 

trying to setup cookies/session
SPOPS::SQLInterface::db_select (86) >> No SQL passed in to execute directly;
building.
SPOPS::SQLInterface::db_select (107) >> SQL for select:
           SELECT  monitored_hosts.monitored_host_id,
monitored_hosts.customer_id, monitored_ho
sts.host, monitored_hosts.ping_type, monitored_hosts.is_alive,
monitored_hosts.email, monitored
_hosts.pager_number, monitored_hosts.paging_configuration_id
             FROM monitored_hosts
            WHERE customer_id = ?

            ORDER BY monitored_host_id

SPOPS::SQLInterface::db_select (125) >> Values bound:  -1
SPOPS::SQLInterface::db_select (141) >> Returning statement handle (after
prepare/execute)
SPOPS::SQLInterface::db_select (86) >> No SQL passed in to execute directly;
building.
SPOPS::SQLInterface::db_select (107) >> SQL for select:
           SELECT  ping_log_id
             FROM ping_log
            WHERE monitored_host_id = ?



SPOPS::SQLInterface::db_select (125) >> Values bound:  46
SPOPS::SQLInterface::db_select (141) >> Returning statement handle (after
prepare/execute)
SPOPS::SQLInterface::db_select (86) >> No SQL passed in to execute directly;
building.
SPOPS::SQLInterface::db_select (107) >> SQL for select:
           SELECT  ping_log.ping_log_id, ping_log.monitored_host_id,
ping_log.was_alive, ping_l
og.ping_time, ping_log.additional_info
             FROM ping_log
            WHERE monitored_host_id = ?

            ORDER BY ping_time DESC

SPOPS::SQLInterface::db_select (125) >> Values bound:  46
SPOPS::SQLInterface::db_select (141) >> Returning statement handle (after
prepare/execute)
trying to setup cookies/session
Chris