View Issue Details

IDProjectCategoryView StatusLast Update
0000548XMB1Bugspublic2020-10-20 18:17
Reportermiqrogroove Assigned Tomiqrogroove  
PrioritynormalSeverityminorReproducibilityrandom
Status closedResolutionfixed 
Product Version1.9.11.15 
Target Version1.9.12Fixed in Version1.9.12 
Summary0000548: Use String Comparison Instead of Parsing Numbers in lastpost
DescriptionRather 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 Informationhttps://sourceforge.net/p/xmb-forum/code/2714/
TagsNo tags attached.
MySQL Version
PHP Version
Web Server
Browser
Flags
Original Reporter
SVN Revision2785

Relationships

related to 0000520 closedmiqrogroove MySQL 5.6 Throws lastpost Comparison Warnings in DEBUG Mode 

Activities

There are no notes attached to this issue.

Issue History

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