Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  File group VS join performance

Author  Topic  -gary Starting Member 1 Post Posted - 2004-09-22 : 13:30:36 I'm writting a new backend for a forum. Wondering if the performance gain from splitting out post text into a seperate table that could be moved to a different file group would outweigh the performace hit from joining the two tables? Would the full-text searching performance increase any with the smaller column count and by virtue of being seperated from the more frequently accessed posts table? This is on a forum that will hit 1/2 million posts this year, so it's not exactly a small ammount of text we're talking about here but not huge either.