Hi
The query is not optimized as it is scanning 45048 rows.
Vertical partitioning can be used because there is a lot of column in single
table.
On Tue, May 6, 2008 at 3:26 PM, Michael Stearne <[EMAIL PROTECTED]>
wrote:
> Hi.
>
> The main table for our site is called properties and it gets hit qui
As a note. The query itself may not be taking long but there are many
"Sorting result " and "Copying to tmp table " in myTop.
Thanks,
Michael
On Tue, May 6, 2008 at 3:26 PM, Michael Stearne <[EMAIL PROTECTED]> wrote:
> Hi.
>
> The main table for our site is called properties and it gets hit q
Hi.
The main table for our site is called properties and it gets hit quite
often (several times per second) something like:
Queries Total: 41,496 Avg/Sec: 6.89 Slow: 0
Cache Hits : 15,096 Avg/Sec: 2.51 Now/Sec: 0.00 Ratio: 36.38%
Threads Total: 1 Active: 1 Cach