[thesite] dean, some oracle things again..

[Dean Mah]

Did you do an explain plan for the query?  See where you need indexes.

I haven't looked at the configuration yet.

Dean


Daniel J. Cody writes:

> i dunno if you've gotten a chance to peak around on the new oracle box
> yet, but here are a couple things we need to look at..
> buffer cache hit rate is in the 30's - db_block_buffers ?
> parse/execute ratio seems to be too high
> 
> also , the front page query is taking like 20 seconds to run.. can we
> make a view out of this:?
> 
> SELECT
>     content.contentid,
>     content.keyphrase,
>     content.contentname,
>     content.synopsis,
>     content.datemod,
>         content.replies,
>     users.userid,
>     users.who,
>     categorys.category,
>     categorys.categoryid,
>     (SELECT Count(*) FROM replies WHERE contentid = content.contentid
> AND datemod > '') AS newcomments
>   FROM
>     content,
>     users,
>     categorys
>   WHERE
>       content.signoff = 1
>       AND content.userid = users.userid
>       AND content.categoryid <> 23
>       AND content.categoryid <> 26
>       AND content.categoryid <> 9741
>       AND content.categoryid = categorys.categoryid
>   
>   ORDER BY
>     content.datemod DESC,
>     content.contentid DESC