Hello everyone, since my last update I fixed some bugs about upgrade and some strings for update the mysql.

Finally, I can say that the speedup wasn’t much superior, maybe get the lft and rgt values in the sql queries add more time in the process. But I have a good news, the speedup in Edit Pages section in admin panel have a good acceleration, see the chart: http://spreadsheets.google.com/pub?key=tvUiOf6bEO5A55cMLjbDTdw&output=html

The last patch is in http://dl.getdropbox.com/u/173207/diff-20090817.patch . Remember, only apply the patch on a test WordPress installation.

Thanks to all, these months were really good .

Sorry for delaying my report by a day. I felt it worth it, as I was finishing up on what should hopefully my final patch for the GSoC term (subject to review by other developers and subsequent editing of course) and some performance results.

• MPTT Patch 08/12/2009
• MPTT Performance Comparison

The patch applies to rev. 11807. Please feel free to test it out and report any issues you experience. Just don’t trust important data to it yet.

Hi everyone, finally I have the patch for MPTT in categories and Pages.

Download the update-pack in http://dl.getdropbox.com/u/173207/pack_20090810.tar.gz

The update-pack includes the patch for WordPress (developer version at today), and two plugins called MPTT, and MPTT-test.

The first plugin MPTT, include a little code for view the tree data in categories and pages (only for view and check the results of add/edit nodes). And with the second plugin MPTT-test, you can insert artificial tree data (hundred and thousands nodes) into categories and get the speedup MPTT V/S Recursive way for get categories.

Remember install the diff patch only in a not important WordPress installation.

Bye bye, and good luck with the tests!

As promised, here’s an updated patch for my MPTT implementation.

• MPTT Patch 08/06/2009

As I warned with previous patches, it’s only been tested on a relatively default install (with all sorts of artificial data of course) on my development machine.  Please do not trust any vital data to it just yet.  I still need to clean up some of the code I think.

In any case, feedback would be appreciated, especially on ways to prevent data corruption (as was addressed in the IRC meeting).

Early this week I spent some time cleaning up a bit of my code and documentation. It still needs some work, but I’m saving that for next week most likely. More recently I went to work on comments. We decided that overhauling the way (paged) comments are handled on the whole would be beyond the scope of my project, so they’ll get a more modest update. What that means is that I’m not entirely sure that my MPTT work will offer a significant performance boost. In fact it might actually end up slower. I’m in the process of debugging it now, so I should be testing its validity later this week.

Hi everyone,

This week I been patching the core of WP, and modifying the admin panel for use MPTT (categories and page sections). I will change the recursive mechanism for get the path of a node by the non-recursive way that use MPTT.

If all go ok, the patch will be ready on the next week.

Bye bye.

Hello everyone, this week i’m making the code for pages, and migrating the mptt plugin to the core of WordPress (for get a patch).

I’m still reading and trying to get more performance for get the tree.

Bye bye!

Paged comments are proving to be much more difficult than they would seem, due to the original code’s convolution. Still trying to figure out how to adapt it to use MPTT without breaking compatibility (at least too much), and if any of the possible solutions offer enough performance gain to be worth it.

Sorry for the late update. This week wasn’t all that productive in terms of writing code. I wrote some of the code for adapting MPTT for comments (or rather the other way around), but ran into a snag for paged comments. Since they’re handled differently than categories and pages, and especially since the WP code handling them is much messier, things get a bit tricky. Most of the week has been spent in planning (and checking with Ryan to see if my plans will break stuff that they shouldn’t).

Well, a week later and I’ve got a new patch. This one includes both some fixes and updates to my previous work on categories as well as a (hopefully) fully-functioning page implementation. This one works from SVN rev. 11716. Once again, it has only undergone testing on my development system and on a near-default WordPress installation, so don’t trust any important data to it. Please to try it out on a test WordPress installation and let me know if anything is broken.

• MPTT Patch for Categories and Pages

I hope to get comments finished up within the next week or so as well. From there on out it should just be testing, performance tweaking, and potentially bug-squashing.