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

[Jan-Erik Revsbech]

Testing if the index is used, can be done by issuing the command EXPLAIN 
before the SELECT query (ie: EXPLAIN SELECT ... FROM tx_realurl_uniqalias 
WHERE ...) in a mysql promt. Mysql will explain to you how the query is 
done. But I think that this might not be the problem. Even 100.000 records 
should not take very long (50 msec) and nowhere near 120sec, so there must 
be another problem. If the pages table is joined in the query, it might take 
much longer though.

I dont have a site with that many pages that uses realurl, so I can't test 
the speed improvements.

/Jan-Erik


----- Original Message ----- 
From: "Kasper Skårhøj" <kasper2005 at typo3.com>
To: "List for Core-/Extension development" <typo3-dev at lists.netfielders.de>
Sent: Monday, October 17, 2005 11:35 AM
Subject: Re: [Typo3-dev] RealURL : high server load and optimization


>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
> _______________________________________________
> Typo3-dev mailing list
> Typo3-dev at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev