View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0000548 | XMB1 | Bugs | public | 2019-12-06 00:59 | 2020-10-20 18:17 |
Reporter | miqrogroove | Assigned To | miqrogroove | ||
Priority | normal | Severity | minor | Reproducibility | random |
Status | closed | Resolution | fixed | ||
Product Version | 1.9.11.15 | ||||
Target Version | 1.9.12 | Fixed in Version | 1.9.12 | ||
Summary | 0000548: Use String Comparison Instead of Parsing Numbers in lastpost | ||||
Description | Rather than using SUBSTRING_INDEX() to find numbers within database columns, it appears to be much more performant if we just place the compared value inside of quotations to make it a string. MySQL can compare a string value to an index much faster than it can scan the column with a functional extra step. | ||||
Additional Information | https://sourceforge.net/p/xmb-forum/code/2714/ | ||||
Tags | No tags attached. | ||||
MySQL Version | |||||
PHP Version | |||||
Web Server | |||||
Browser | |||||
Flags | |||||
Original Reporter | |||||
SVN Revision | 2785 | ||||
related to | 0000520 | closed | miqrogroove | MySQL 5.6 Throws lastpost Comparison Warnings in DEBUG Mode |
Date Modified | Username | Field | Change |
---|---|---|---|
2019-12-06 00:59 | miqrogroove | New Issue | |
2019-12-06 01:00 | miqrogroove | Relationship added | related to 0000520 |
2019-12-29 02:43 | miqrogroove | Assigned To | => miqrogroove |
2019-12-29 02:43 | miqrogroove | Status | new => confirmed |
2019-12-29 02:47 | miqrogroove | Additional Information Updated | |
2019-12-29 02:48 | miqrogroove | Target Version | => 1.9.12 |
2020-08-24 10:27 | miqrogroove | Status | confirmed => resolved |
2020-08-24 10:27 | miqrogroove | Resolution | open => fixed |
2020-08-24 10:27 | miqrogroove | Fixed in Version | => 1.9.12 |
2020-08-24 10:27 | miqrogroove | SVN Revision | => 2785 |
2020-10-20 18:17 | miqrogroove | Status | resolved => closed |