[TYPO3] search for large sites

[Ernesto Baschny [cron IT]]

Martin Kutschker schrieb:

>> Valery Romanchev wrote:
>>
>>> I think MySQL FULLTEXT search in MySQL 4.x and 5.x can handle 50000
>>> documents
>>
>> Unfortunately InnoDb does not support FULLTEXT. Also I am not sure if
>> FTS search commands are compatible with other databases.
> 
> I had the idea to store the "real text" for each page in a separate
> table and to create A FULLTEXT index on this table.
> 
> The "real text" is a straight text only version without any UI (think of
> a text-only print version).


You could also use the part of the page that indexed_search already
uses, which is either the entire page or the parts delimited by those
<!--TYPO3SEARCH_begin--> tags.

And can "FULLTEXT" mysql query cope with weighting based on the
occurence location (title-tag, h1, h2, h3, ...)?

Cheers,
Ernesto