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

[Brice Bernard]

Because calculating the 1st hit takes too much time to plan daily
update. (The whole browsing takes toot much time).

-brice-

2005/10/17, Kasper Skårhøj <kasper2005 at typo3.com>:
> If your 2nd page hit takes lots of time and that is served by a reverse proxy,
> TYPO3 is never invoked, right? How can realurl slow that down then?
>
> - kasper
>
>
>
> On Monday 17 October 2005 12:04, Brice Bernard wrote:
> > 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
> >
> > _______________________________________________
> > 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
>