Itamar Tzadok

Could be a theme issue. If the block was set to appear in a certain region that no longer exist for the page layout of the user profile after the upgrade, it will not show up. Have you tried another theme?

Try the navigation block. That's the thing with Moodle 2. Almost every little management button/link was moved into either the navigation block or the settings block.

It works here when you go to the designated user profile.

Same results with your patch applied. So it seems that performance issues of the Database module queries go beyond that one join.

I've just done a quick performance comparison between the Database module and the Dataform module on displaying 1000 entries (out of 2000) each entry with a text field and a text area field and some content in each field.

The Database takes more than twice as long to display the entries and makes 3 times more DB reads.