Re: help wit query optimization (cont'd)

[Sebastian Mendel]

Perrin Harkins schrieb:
> On Jan 4, 2008 5:51 PM, Eben <eben@stripped> wrote:
>> The resultset is paginated on the front end using the
>> SQL_CALC_FOUND_ROWS functionality...
> 
> Usually a bad idea:
>
> http://www.mysqlperformanceblog.com/2007/08/28/to-sql_calc_found_rows-or-not-to-sql_calc_found_rows/

usually ... but i do not know of any index capable of having FULLTEXT and
'normal' fields in one index

> WHERE MATCH table_2.field AGAINST ('value')
> AND table_2.current = 1
> AND table_2.shared_id IN (SELECT shared_id FROM table_1_view) 

or am i wrong?

-- 
Sebastian