View Issue Details

IDProjectCategoryView StatusLast Update
0000548XMB1Bugspublic2019-12-29 02:48
ReportermiqrogrooveAssigned Tomiqrogroove 
Status confirmedResolutionopen 
Product Version1.9.11.15 
Target Version1.9.11.16Fixed in Version 
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 Information
TagsNo tags attached.
MySQL Version
PHP Version
Web Server
Original Reporter
SVN Revision


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


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 View Revisions
2019-12-29 02:48 miqrogroove Target Version =>