List:General Discussion« Previous MessageNext Message »
From:Sebastian Mendel Date:January 9 2008 9:33am
Subject:Re: help wit query optimization (cont'd)
View as plain text  
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
Thread
help wit query optimization (cont'd)Eben4 Jan
  • Re: help wit query optimization (cont'd)Perrin Harkins5 Jan
    • Re: help wit query optimization (cont'd)Moon's Father5 Jan
    • Re: help wit query optimization (cont'd)Sebastian Mendel9 Jan
      • Re: help wit query optimization (cont'd)Perrin Harkins9 Jan
        • Re: help wit query optimization (cont'd)Sebastian Mendel9 Jan
          • Re: help wit query optimization (cont'd)Perrin Harkins9 Jan