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

[Andreas Schwarzkopf]

AFAIK a blob field can not have an index.

grtx

Andreas

Brice Bernard schrieb:
> I tried to ALTER TABLE `tx_realurl_uniqalias` ADD INDEX (
> `value_alias` ) but MySQL said: #1170 - BLOB/TEXT column 'value_alias'
> used in key specification without a key length...
> 
> I don't know how to solve it...
> 
> 2005/10/17, Rudy Gnodde <gnodde.rudy at wag.nl>:
> 
>>Hello Brice,
>>
>>You can try setting indexes on the different fields in the database
>>(value_alias, field_alias, field_id, tablename and value_id) if they're
>>not set already. That should speed things up.
>>
>>Met vriendelijke groet,
>>Rudy Gnodde
>>
>>WIND Internet
>>Tijnjedyk 89
>>8936 AC Leeuwarden
>>Tel: 058 - 280 28 87
>>Fax: 058 - 288 13 91
>>E-mail: gnodde.rudy at windinternet.nl
>>Internet: www.windinternet.nl
>>------------------------------------------------------------------------
>>--------------------------------------------------------------------
>>De informatie verzonden met dit e-mailbericht (en bijlagen) is
>>uitsluitend bestemd voor de geadresseerde(n) en zij die van de
>>geadresseerde(n) toestemming hebben dit bericht te lezen. Gebruik door
>>anderen dan geadresseerde(n) is verboden. De informatie in dit
>>e-mailbericht (en de bijlagen) kan vertrouwelijk van aard zijn en kan
>>binnen het bereik vallen van een geheimhoudingsplicht.
>>WIND Internet is niet aansprakelijk voor schade ten gevolge van het
>>gebruik van elektronische middelen van communicatie, daaronder begrepen
>>-maar niet beperkt tot- schade ten gevolge van niet aflevering of
>>vertraging bij de aflevering van elektronische berichten, onderschepping
>>of manipulatie van elektronische berichten door derden of door
>>programmatuur/apparatuur gebruikt voor elektronische communicatie en
>>overbrenging van virussen en andere kwaadaardige programmatuur.
>>
>>Any information transmitted by means of this e-mail (and any of its
>>attachments) is intended exclusively for the addressee or addressees and
>>for those authorized by the addressee or addressees to read this
>>message. Any use by a party other than the addressee or addressees is
>>prohibited. The information contained in this e-mail (or any of its
>>attachments) may be confidential in nature and fall under a duty of
>>non-disclosure.
>>WIND Internet shall not be liable for damages resulting from the use of
>>electronic means of communication, including -but not limited to-
>>damages resulting from failure or delay in delivery of electronic
>>communications, interception or manipulation of electronic
>>communications by third parties or by computer programs used for
>>electronic communications and transmission of viruses and other
>>malicious code.
>>------------------------------------------------------------------------
>>--------------------------------------------------------------------
>>
>>>-----Oorspronkelijk bericht-----
>>>Van: typo3-dev-bounces at lists.netfielders.de [mailto:typo3-dev-
>>>bounces at lists.netfielders.de] Namens Brice Bernard
>>>Verzonden: maandag 17 oktober 2005 9:19
>>>Aan: List for Core-/Extension development
>>>Onderwerp: [Typo3-dev] RealURL : high server load and optimization
>>>
>>>I have a website storing hundreds of pages, the problem comes from
>>>realurl extension and sql querie optimization.
>>>My table 'tx_realurl_uniqalias' stores 100 000 records and queries to
>>>render the page is like this :
>>>
>>>SELECT value_id
>>>FROM tx_realurl_uniqalias
>>>WHERE
>>>value_alias="my-page"
>>>AND field_alias="title"
>>>AND field_id="uid"
>>>AND tablename="tx_myextension"
>>>
>>>SELECT value_alias
>>>FROM tx_realurl_uniqalias
>>>WHERE
>>>value_id="89031"
>>>AND field_alias="title"
>>>AND field_id="uid"
>>>AND tablename="tx_myextension"
>>>
>>>Because of these queries, page generation can take up to 120 second!!!
>>>(about 1 or 2 seconds per request).
>>>
>>>Does anyone ever face this kind of problem and knows how to solve it?
>>>_______________________________________________
>>>Typo3-dev mailing list
>>>Typo3-dev at lists.netfielders.de
>>>http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev
>>
>>_______________________________________________
>>Typo3-dev mailing list
>>Typo3-dev at lists.netfielders.de
>>http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev
>>