Welcome to Geeklog, Anonymous Wednesday, December 04 2024 @ 05:25 am EST
Geeklog Forums
Database indexes
Blaine in Maine
Anonymous
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
I am specifically interested in the gl-forum_settings table and the gl_forum_log table?
Thanks in advance.
~L
12
13
Quote
Status: offline
Fanny Mae
Forum User
Junior
Registered: 06/03/04
Posts: 22
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
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
13
9
Quote
Status: offline
Fanny Mae
Forum User
Junior
Registered: 06/03/04
Posts: 22
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
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
13
16
Quote
All times are EST. The time is now 05:25 am.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content