Last modified: 2009-12-16 15:43:04 UTC
On some over-populated properties, the page listing (showList()) on the Property namespace can trigger huge database queries that hang the application and DB. I've added a configuration for disabling this feature.
Created attachment 6854 [details] New $smwgPropertyPageShowList configuration directive
The patch would actually disable all listings (including subproperties) and it would also hide the property listings on Type pages and the element listings on Concept pages. I have thus implemented a better solution: it is now possible to set the parameter $smwgPropertyPagingLimit to 0 for hiding the property page listings. By the way: the query is just a simple DB lookup that is always limited to 25 results. It would be interesting to learn why it caused performance issues on your site at all. Retrieving 25 rows from a table is not really that challenging for a RDBMS even if the table is large.
Even better! Thanks. It's interesting why these queries are so time-consuming. I will look into it.