On the topic table, it would probably help to have and index on forum and pid. The pid is used quite often to retrieve data. Dwight dwight at trumbower.com