Profile My Little Forum - some suggestions (General)

by Auge ⌂ @, Tuesday, March 21, 2017, 08:03 (244 days ago) @ Milo


Okay. Thank you! I believe, we should check all columns in WHERE-conditions and/or the column-conditions in JOIN statements (e.g. <foo> ON <bar>). These columns must have an INDEX.

I don't know, if it is useful, to set every column, that is/could be membered in a JOIN, as an index. To manage the indexes takes also executing time. But the often in JOINs used
columns should be indexed. The first column, that came in my mind while reading this thread is the column category of the entries table.

Tschö, Auge

further development of mlf1

Complete thread:

 RSS Feed of thread

powered by my little forum