Skip to:
Content

bbPress.org

Changeset 1428


Ignore:
Timestamp:
04/22/2008 03:58:19 AM (16 years ago)
Author:
sambauers
Message:

Add MySQL index to speed up sticky topic queries.

Files:
4 edited

Legend:

Unmodified
Added
Removed

  • branches/0.9/bb-admin/upgrade-schema.php

    r1427 r1428  
    7474  KEY topic_slug (topic_slug),
    7575  KEY forum_time (forum_id,topic_time),
    76   KEY user_start_time (topic_poster,topic_start_time)
     76  KEY user_start_time (topic_poster,topic_start_time),
     77  KEY forum_stickies (topic_status,forum_id,topic_sticky,topic_time)
    7778) $charset_collate;";
    7879

  • branches/0.9/bb-includes/functions.php

    r1427 r1428  
    14421442        break;
    14431443    case 'bb_db_version' :
    1444         return '1426'; // Don't filter
     1444        return '1428'; // Don't filter
    14451445        break;
    14461446    case 'html_type' :

  • trunk/bb-admin/upgrade-schema.php

    r1426 r1428  
    7474  KEY topic_slug (topic_slug),
    7575  KEY forum_time (forum_id,topic_time),
    76   KEY user_start_time (topic_poster,topic_start_time)
     76  KEY user_start_time (topic_poster,topic_start_time),
     77  KEY forum_stickies (topic_status,forum_id,topic_sticky,topic_time)
    7778) $charset_collate;";
    7879

  • trunk/bb-includes/functions.php

    r1426 r1428  
    14411441        break;
    14421442    case 'bb_db_version' :
    1443         return '1426'; // Don't filter
     1443        return '1428'; // Don't filter
    14441444        break;
    14451445    case 'html_type' :
Note: See TracChangeset for help on using the changeset viewer.