Posted on: 01/28/09 05:56pm
By: Anonymous (Blaine in Maine)
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
Re: Database indexes
Posted on: 01/31/09 04:53pm
By: Fanny Mae
Nobody have an answer to database indexes? I'm interested
Re: Database indexes
Posted on: 01/31/09 05:05pm
By: Dirk
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
Re: Database indexes
Posted on: 02/01/09 04:55pm
By: Fanny Mae
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
Re: Database indexes
Posted on: 02/02/09 10:27am
By: Fanny Mae
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