| 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_ROWS | wassuuuub | 4 Dec |
| • Re: fulltext search speed issue with SQL_CALC_FOUND_ROWS | Matt W | 4 Dec |
| • Re: fulltext search speed issue with SQL_CALC_FOUND_ROWS | tk | 5 Dec |
| • Re: fulltext search speed issue with SQL_CALC_FOUND_ROWS | Sergei Golubchik | 5 Dec |
| • Re: fulltext search speed issue with SQL_CALC_FOUND_ROWS | tk | 5 Dec |
| • Re: fulltext search speed issue with SQL_CALC_FOUND_ROWS | Sergei Golubchik | 5 Dec |
| • Re: fulltext search speed issue with SQL_CALC_FOUND_ROWS | tk | 15 Dec |
| • RE: fulltext search speed issue with SQL_CALC_FOUND_ROWS | Gunnar von Boehn | 5 Dec |
