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

[Brice Bernard]

I made an extension storing and displaying 350 000 records. It takes
real long time to display the page but I also use page reverse proxy
in order to make the 2nd render of the page as fast as static. The
time taken is caused by RealUrl of course but maybe also because of my
code neeed improvement.

In order to prepare/calculate the 1st rendering by myself I use
httrack command to browse all the website (and so generate the cache
for reverse proxy). I imagine I can clear the cache (http / typo3 and
realUrl's cache) then run httrack for 24h and count how many pages
were downloaded then do it again with the your dev version and compare
these results...

2005/10/17, Kasper Skårhøj <kasper2005 at typo3.com>:
> 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
>