Avatar

Profile My Little Forum - some suggestions (General)

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

Hello

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