[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