#2357 - Force index support

Identifier #2357
Issue type Feature request or suggestion
Title Force index support
Status Completed
Handling member Chris Graham
Addon core_database_drivers
Description Add code to force indexes on table names. Drivers not supporting it would do a null-op.
Steps to reproduce

Additional information We can clean up a lot of code like:

$query = 'SELECT * FROM ' . $this_ref->connection->get_table_prefix() . 'f_topics top';
if (strpos(get_db_type(), 'mysql') !== false) {
$query .= ' USE INDEX (topic_order_4)';
}

to like:

$query = 'SELECT * FROM ' . $this_ref->connection->table_with_index($this_ref->connection->get_table_prefix() . 'f_topics', 'topic_order_4', 'top');
Funded? No
The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".

Rating

Unrated