[TYPO3] [TYPO3-dev] Indexed Search Performance Improvement

[Ernesto Baschny [cron IT]]

Martin Kutschker wrote: on 28.02.2007 17:16:

>> i asked for that index also a while ago. The answer was, we can't
>> change to be compatible to DBAL.
>> But why don't filter that index in DBAL ?
> 
> The problem is that the syntax for the SQL query is different for full
> text indices. So indexed search needs to know if it runs on Mysql. But
> we could change indexed search so it knows about DBAL (a sysext after
> all). There are other places in the Core where we check for the presence
> of specific extensions.

An idea would be a indexed_search_mysql "add-on extension" which uses
mysql specific SQL, while indexed_search continues to work with basic
SQL-only. In future we could also have "indexed_search_oracle" etc for
speedups on other platforms.

Cheers,
Ernesto