0000548: Use String Comparison Instead of Parsing Numbers in lastpost

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
Git Commit

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