View Single Post
Old April 30th, 2005, 12:41 AM   #6 (permalink)
ConqSoft
Ultimate Member
Verified Customer
 
ConqSoft's Avatar
 
Join Date: Nov 2003
Location: Raleigh, NC
Posts: 1,417
Re: username in lots of tables

So did you change all the same stuff in vBulletin itself too?

thread table has postuserid, along with postusername, and lastposter is the text name of the user as well.

forum table stores the whole title of the last posted thread, along with the threadid, and also keeps up with the lastposter userid and username.

All this is done for a reason... Lots of joins will kill you in a high traffic situation. (But, you already know that since you're a graduate of database design. )
ConqSoft is offline   Reply With Quote