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

[Michiel Roos]

On Mon, 17 Oct 2005 11:48:23 +0200, Jan-Erik Revsbech wrote:

> 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

There is an extension called wizard_crpagetree with which you can generate
a lot of pages in one go.

Michiel