Avatar

Profile My Little Forum - some suggestions (General)

by Milo ⌂, Tuesday, March 21, 2017, 08:30 (266 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

--
Surveyor-Software: Geodetic Network Adjustment & Deformation-Analysis and Transformation


Complete thread:

 RSS Feed of thread

powered by my little forum