[Typo3-dev] RealURL : high server load and optimization

[Jan-Erik Revsbech]

----- Original Message ----- 
From: "Andreas Schwarzkopf" <schwarzkopf.no.spam at artplan21.de>
Newsgroups: typo3.dev
To: <typo3-dev at lists.netfielders.de>
Sent: Monday, October 17, 2005 10:24 AM
Subject: Re: [Typo3-dev] RealURL : high server load and optimization


> AFAIK a blob field can not have an index.

This is not true, but you need to specify how much of the blob field you 
want to index. Example:

ALTER TABLE `tx_realurl_uniqalias` ADD INDEX value_alias (value_alias(25))

will create an index using 25 characters of the blob field.

I would however suggest to make and index using all the fields like this
ALTER TABLE `tx_realurl_uniqalias` ADD INDEX  mydindexname 
(value_alias(25),field_alias(25),field_id,tablename)

/Jan-Erik