Sep 29, 2017 06:23 PM|mgebhard|LINK
You should always use proper types otherwise you'll constantly need to cast from a string and validate.
Change Time to a
Time type. Change the YearMonth to an INT that must be greater than, at least, 99999. Perhaps greater than 190000.
Shall I include all the columns of my search param and make them index ie company, mod, yearmonth or just one of them.
Create indexes on the fields or combination of fields that will be queried most.