07-19-2012, 11:55 PM
Hi all:
Does it make sense to change the order of the results in SelectProduct.php to
ORDER BY stockmaster.discontinued, stockmaster.stockid instead of current ORDER BY stockmaster.stockid?
It will return the current items (not discontinued) results first and then the obsolete (discontinued) ones. Most probably users are searching current items not obsolete ones, so chances are this order will make searches more efficient.
If it's acceptable for the community I'll code it...
Does it make sense to change the order of the results in SelectProduct.php to
ORDER BY stockmaster.discontinued, stockmaster.stockid instead of current ORDER BY stockmaster.stockid?
It will return the current items (not discontinued) results first and then the obsolete (discontinued) ones. Most probably users are searching current items not obsolete ones, so chances are this order will make searches more efficient.
If it's acceptable for the community I'll code it...