Geeklog Forums

Is there a list anywhere that shows what indexes are set up for the various gl_forum tables?

I am specifically interested in the gl-forum_settings table and the gl_forum_log table?

Thanks in advance.

~L

Nobody have an answer to database indexes? I'm interested

The easiest way to find that information would be to look at the database in phpMyAdmin. Or use the forum's SQL install file in plugins/forum/sql

bye, Dirk

Thanks Dirk,

While looking at the database I saw that one did not have an index and another had a duplicate index. I figured there should be a list of indexes available, so that I could correct, and or replace any missing indexes.

I'll try plugins/forum/sql

Looks like we were missing the second index on forum_id.

Not sure if that is what was causing the posts in a thread to show out of order, but hope so. All other indexes were OK.

Thanks Dirk


PRIMARY KEY (forum_id),
KEY forum_cat (forum_cat),
KEY forum_id (forum_id) <-----------MISSING