CPU intensive fetch

Could someone perhaps help to explain the following. The query is VERY long so I haven't included it, but no table (7 of them) has more than 20 rows. The CPU time is genuine, it takes over the machine for 2 minutes, which seems excessive give the disk, query, and current values.

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------

Parse        1      0.02       0.02          0          0          0           0
Execute      1     18.65      18.68          0          0          0           0
Fetch        2    118.81     120.05          1         19         28           1


------- ------  -------- ---------- ---------- ---------- ----------  ----------

total        4    137.48     138.75          1         19         28           1

TIA Eric  

-- 
Sent  by eric from  deptj in field demon element  from  co within field uk
This is a spam protected message. Please answer with reference header.
Posted via http://www.usenet-replayer.com/cgi/content/new