phpwiki-talk

[Phpwiki-talk] IsWIkiPage() is expensive

[Arno H. <aho...@xm...>]

Hi all,

I nearly killed my wiki by adding a page which ranks pages by=20
click-distance (see: http://senseis.xmp.net/?PagesByDistance). In my firs=
t=20
try, the page contained all other (300) pages with real wikilinks.

So, whenever the page got displayed IsWikiPage() got called 300 times,=20
which translates to 300 SQL queries for one page. The web server almost=20
came to a halt due to mysql eating up all its resources.

A painful lesson.
We need to improve this behaviour during 1.3.x

/Arno

Re: [Phpwiki-talk] IsWIkiPage() is expensive

[Steve W. <sw...@wc...>]

On Sat, 3 Feb 2001, Arno Hollosi wrote:

> I nearly killed my wiki by adding a page which ranks pages by 
> click-distance (see: http://senseis.xmp.net/?PagesByDistance). In my first 
> try, the page contained all other (300) pages with real wikilinks.

I told you that Travelling Salesman problem still hasn't been solved! ;-)

> So, whenever the page got displayed IsWikiPage() got called 300 times, 
> which translates to 300 SQL queries for one page. The web server almost 
> came to a halt due to mysql eating up all its resources.
> 
> A painful lesson.
> We need to improve this behaviour during 1.3.x

OK, I'l add caching to the todo list.

~swain

...............................ooo0000ooo.................................
   Hear FM quality freeform radio through the Internet: http://wcsb.org/
                     home page: www.wcsb.org/~swain