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

[Peter Russ]

Ernesto Baschny [cron IT] schrieb:
> 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

Instead of suppling different versions I would add some more hooks so 
the DB specific parts could be optimized more lean.

Regs. Peter.


-- 
Fiat lux!
Docendo discimus.
_____________________________
4Many® Services
openBC: http://www.openbc.com/go/invuid/Peter_Russ