Re: manual-lookup revision

From: Date: Wed, 14 May 2003 17:37:27 +0000
Subject: Re: manual-lookup revision
References: 1 2  Groups: php.mirrors 
Request: Send a blank email to php-mirrors+get-17646@lists.php.net to get a copy of this message
Can you point me to the file(s) that does this? Reducing the load from the manual pages is next on our hitlist :) ATM, the database maps lang+keyword => relative URL for the manual page, so the language switch stuff can be implemented using quite simply by querying for languages that match the relevant page. --Wez. On Wed, 14 May 2003, Gabor Hojtsy wrote: > > The manual function lookup code was creating quite a lot of load on > > www.php.net due to a large number of stat() syscalls. > > > > To alleviate this problem, we've put in place an SQLite database to cache > > the directory structure of the manual pages. This, combined with some > > other tweaks to that machine has helped reduce the load to sane levels. > > > > SQLite [1] is an embedded SQL database implementation that has very high > > performance for applications with low write concurrency, making it ideal > > for our particular problem. > > Well this sounds great. It would be nice to have more mirrors adopting > this stuff. Then we would be able to move other things to this DB also. > This thing will probably be ideal to use for language switch listings > (which also make stats calls for every language on every manual page to > make the switch dropdown available for that particular page). And it > would also be cool for docs.php which also stats the files. Using the > same database we already have. > > Goba > > >

« previous php.mirrors (#17646) next »