Avatar

Profile My Little Forum - some suggestions (General)

by Micha ⌂, Tuesday, March 21, 2017, 08:30 (2564 days ago) @ Auge

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


Complete thread:

 RSS Feed of thread