List:General Discussion« Previous MessageNext Message »
From:<wassuuuub Date:December 4 2003 3:13pm
Subject:fulltext search speed issue with SQL_CALC_FOUND_ROWS
View as plain text  
I have some_table with 100,000 rows and with an
average of 500 words in some_column of each row. When
i do a fulltext search on this table using a query
such as the following, all of my results are under 0.1
seconds:

SELECT something
FROM some_table
WHERE MATCH (some_column) AGAINST ('some_search_term')
LIMIT 0,10

However, when i add the SQL_CALC_FOUND_ROWS keyword
like in the following query, some queries take longer
than 1 minute:

SELECT SQL_CALC_FOUND_ROWS something
FROM some_table
WHERE MATCH (some_column) AGAINST ('some_search_term')
LIMIT 0,10

How can there be a huge difference in speed if both
queries always return the exact same results?

Thanks,
TK

__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
Thread
fulltext search speed issue with SQL_CALC_FOUND_ROWSwassuuuub4 Dec
  • Re: fulltext search speed issue with SQL_CALC_FOUND_ROWSMatt W4 Dec
Re: fulltext search speed issue with SQL_CALC_FOUND_ROWStk5 Dec
  • Re: fulltext search speed issue with SQL_CALC_FOUND_ROWSSergei Golubchik5 Dec
    • Re: fulltext search speed issue with SQL_CALC_FOUND_ROWStk5 Dec
      • Re: fulltext search speed issue with SQL_CALC_FOUND_ROWSSergei Golubchik5 Dec
        • Re: fulltext search speed issue with SQL_CALC_FOUND_ROWStk15 Dec
RE: fulltext search speed issue with SQL_CALC_FOUND_ROWSGunnar von Boehn5 Dec