[TYPO3-50-general] Evaluating FLOW3 for a new project

Martin Kutschker masi-no at spam-typo3.org
Thu Apr 9 18:14:04 CEST 2009


Ries van Twisk schrieb:
>>
>>> It's not really awkward once you know the implementation
>>> and why it was created in such a way.
>>
>> I only read the docs and it wasn't an easy read for me ;)
> 
> We put indexes on the tables much like this:
> 
> CREATE INDEX tbl_copy_translation_idx_ts_2
>   ON mkt.tbl_copy_translation
>   USING gin
>   (to_tsvector('english'::regconfig, copy))
>   WHERE lang_id = 2;

Wow, I can add an index on a part of a table by using a WHERE clause?!?
Amazing.

> The table has a record for each language in the same table. We
> 
> lang_id is in this case english, this speeds up the system enormously.

Something missing?

Masi


More information about the TYPO3-project-5_0-general mailing list