| |
| | zForum - Zope Based Message Boards |
 | | zfc (first row in the above section) was not indexed, even with cat_id being the primary key for that table, that is undertandable since the zfc (forum categories) has to be sweeped 100% anyway, but the yielding performance is way better, just there 1.0.5 *has* to be faster in generate the main page. |
 | | Now, We have to look at other options as far as the optmization goes, the way it is now, it is as optimize as it can be, I'd be surprised if this query takes more than a couple of seconde on a 100,000+ records system. |
 | | select zfc.*, zf.forum_id, zf.forum_title, zf.forum_desc, zf.moderation_flag, zf.anonymous_viewaccess, zf.add_postings_access_roles, zf.admin_min_access_roles, sum(zt.hits) as hits from zf_forum_category as zfc left join zf_forum as zf on zfc.cat_id = zf.cat_id left join zf_topic as zt on zt.forum_id = zf.forum_id group by zf.forum_id, zf.forum_title, zf.forum_desc, zf.moderation_flag, zf.anonymous_viewaccess, zf.add_postings_access_roles, zf.admin_min_access_roles, zfc.cat_id, zfc.cat_name, zfc.cat_desc, zfc.cat_visible_to |
| www.zforum.org /view_topic?topic_id=437 (2262 words) |
|