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

[Kasper Skårhøj]

I would be willing to add this index to my dev-version of realurl right away 
PROVIDED that someone will test it and confirm that the MySQL lookup actually 
a) uses this index for the mentioned queries and b) speeds up things.

- kasper


On Monday 17 October 2005 10:35, Jan-Erik Revsbech wrote:
> ----- 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
>
>
> _______________________________________________
> Typo3-dev mailing list
> Typo3-dev at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev

-- 
- kasper

-----------------
Think future, not feature