Customizing SMF > SMF Coding Discussion

Some new coding techniques

<< < (4/4)

vbgamer45:
You should add some indexing keys on

`authorid` int(11) NOT NULL,
`modid` int(11) NOT NULL,

Simple to do
ALTER TABLE tablename add index (authorid)

Generally with indexes you add index if you are searching/loooking up data on the where clause and not using true/false.

Yoshi:

--- Quote from: vbgamer45 on May 08, 2012, 02:35:15 PM ---You should add some indexing keys on

`authorid` int(11) NOT NULL,
`modid` int(11) NOT NULL,

Simple to do
ALTER TABLE tablename add index (authorid)

Generally with indexes you add index if you are searching/loooking up data on the where clause and not using true/false.

--- End quote ---
Oh, thanks! I thought I was doing lots of things wrong in the database lol.

Probably done in Suki's version already, though :)

Navigation

[0] Message Index

[*] Previous page