In WordPress 2.5.1 – finding the missing comments in the admin -> show all comments

by Jason L Froebe on June 18, 2008, one comment

If you have comments in your WordPress 2.5.1 blog but the admin page says you don’t: Then you probably have a missing index on the table wp_comments.  You just need to add an index on column comments_date_gmt:

Share Button

Finding suspect indexes in Sybase ASE

by Jason L Froebe on September 21, 2006, no comments

Problem: ASE does not use an index on a table because it is marked suspect Index id 2 on table id 864003078 cannot be used in the optimization of a query as it is SUSPECT. Please have the SA run DBCC REINDEX on the specified table. Index id 2 on table id 864003078 cannot be […]

Share Button
Facebook login by WP-FB-AutoConnect