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

[Brice Bernard]

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
>