Slow Result Count query

Hi David

Any idea how I can speed this query up? Have just over 150K products in a single table.
Done a couple of modifications to the script already so not sure if its something I've changed..

This is what appears in my slow-query-log file..

# Query_time: 40 Lock_time: 0 Rows_sent: 1 Rows_examined: 7479
use **_compare;
SELECT COUNT(DISTINCT(name)) as resultcount FROM `***_products` WHERE MATCH name AGAINST ('kodak camera');