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

[Brice Bernard]

...Even wekkly update...

2005/10/17, Brice Bernard <brikou at gmail.com>:
> 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
> >
>