Profile My Little Forum - some suggestions (General)
Hi,
To manage the indexes takes also executing time.
Of course, but it seems to be small. The column user_id
was not indexed but, I believe, it is an important and often used column for joining - why this column is not set as FOREIGN KEY
?
The first column, that came in my mind while reading this thread is the column
category
of the entries table.
This column is set as key e.g.
KEY category (category)
. Isn't it similar to an INDEX
?
/Micha
--
applied-geodesy.org - OpenSource Least-Squares Adjustment Software for Geodetic Sciences