OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
help wit query optimization (cont'd)

From: Eben (ebenbakedbean.net)
Date: Fri Jan 04 2008 - 16:51:02 CST

I left something out, the query looks like:
SELECT SQL_CALC_FOUND_ROWS table_1.id,table_2.*
FROM table_2
LEFT JOIN table_1 ON table_2.shared_id = table_1.shared_id
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)
LIMIT 0,10

The resultset is paginated on the front end using the
SQL_CALC_FOUND_ROWS functionality...

thanks,
Eben

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql