View Issue Details

IDProjectCategoryView StatusLast Update
0000548XMB1Bugspublic2019-12-29 02:48
ReportermiqrogrooveAssigned Tomiqrogroove 
PrioritynormalSeverityminorReproducibilityrandom
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 Informationhttps://sourceforge.net/p/xmb-forum/code/2714/
TagsNo tags attached.
MySQL Version
PHP Version
Web Server
Browser
Flags
Original Reporter
SVN Revision

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