From: Reini U. <ru...@x-...> - 2004-12-10 14:56:07
|
Charles Corrigan schrieb: > On 02 December 2004 10:38, Reini Urban wrote: >>You have been warned. The pagedata and versiondata cache >>revamp is not finished, it's dirty, and I want to clean >>it up without using too much memory. > > How close to complete/reasonably stable is this rewrite? I have been > working on other things (real life and migrating an existing Wiki to a new > site, including a large content cleanup). I am now close to being able to > look at code (or at least developing test cases) again. db-side it is stable, just for the presentation I'm not sure. We have now the unoptimized version in CVS, which ignores the fact that on an early stage (keyword extraction does a partial page iteration) some later needed pagedata can be stored in the pagedata cache. When I enable that again it will save us about 10-20 sql queries. Personally I haven't seen any problem so far with the current cache code. Other than your posted cornercases, which were very helpful. I'm now adding some other bits and pieces to the WikiDB and work on the cache-optimization after that is finished. I just refactored _cached_html yesterday, which saves as much more memory on SQL. I want to add some better migration hints. Currenty it SQL-fails until you run ?action=upgrade. Then I want to debug pagedata and versiondata cache again and optimize it, both for memory and run-time efficiency. About two days. But some postgresql-cygwin and perl-libwin32 problems in other projects are also pending, so it could be more than two days. -- Reini Urban http://phpwiki.org/ |