Skip to:
Content

Changeset 1428


Ignore:
Timestamp:
04/22/08 03:58:19 (6 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.