Perrin Harkins schrieb:
> On Jan 4, 2008 5:51 PM, Eben <[EMAIL PROTECTED]> 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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
