Tree View with PHP 5, MySql and Stored Procedures

The time saving performance of Stored Procedures with MySql is well known - they are stored and executed directly on the server. This example of a tree view navigation with Stored Procedures demonstrates this in fact impressively. Even with four Stored Procedures (one cares about the main content, one about the content for the sub tree, one counts all records and one splits the main tree in two corresponding parts), it's only one hundred of a second slower then a XML loop with XPath (besides that XML files are not so easy to maintain as database tables). The Stored Procedures make use of the CONCAT() method and the INSTR() function of MySql. For this tree view you need only two lines to make it work.