View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002357 | Composr | core_database_drivers | public | 2016-03-30 13:43 | 2017-11-21 22:51 |
| Reporter | Chris Graham | Assigned To | Chris Graham | ||
| Severity | Feature-request | ||||
| Status | resolved | Resolution | fixed | ||
| Product Version | |||||
| Fixed in Version | |||||
| Summary | 0002357: Force index support | ||||
| Description | Add code to force indexes on table names. Drivers not supporting it would do a null-op. | ||||
| 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'); | ||||
| Tags | No tags attached. | ||||
| Time estimation (hours) | 3 | ||||
| Sponsorship open | |||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2016-03-30 13:43 | Chris Graham | New Issue | |
| 2017-11-21 22:51 | Chris Graham | Status | non-assigned => resolved |
| 2017-11-21 22:51 | Chris Graham | Resolution | open => fixed |
| 2017-11-21 22:51 | Chris Graham | Assigned To | => Chris Graham |
