Re: query performance

From: Jim Poe <jpoe_at_fulcrumit.com>
Date: 11 Oct 2001 19:30:31 GMT
Message-ID: <9q4s0n$q5a@dispatch.concentric.net>

I didn't have timed statistics turned on in the previouse tkprof results

TEST

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

Parse 1 65.17 65.62 0 3451 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.73 0.77 0 48129 5616 19
------- ------ -------- ---------- ---------- ---------- ---------- ------

total 3 65.90 66.39 0 51580 5616 19

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 19

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

Parse 1 3.05 3.42 0 2042 23 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.15 0.26 0 1844 3004 20
------- ------ -------- ---------- ---------- ---------- ---------- ------

total 3 3.20 3.68 0 3886 3027 20

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 19

--
Jim Poe (jpoe_at_fulcrumit.com)

Received on Thu Oct 11 2001 - 14:30:31 CDT