Optimal forum struktur
HejHvordan laver jeg en optimal forum struktur der har masser af fart?
Jeg har fundet ud af at den jeg har lige nu ikke er optimal.. Forslag modtages..
Forum_Thread:
SELECT [ThreadID]
,[ParentID]
,[IsParent]
,[LastID]
,[ThreadCount]
,[ViewCount]
,[ForumID]
,[UserID]
,[CreateDate1]
,[EditDate2]
,[Subject]
,[Content]
,[Visible]
,[Lock]
,[SiteID]
,[SystemMsg]
,[StaticUser]
,[StaticUserEmail]
,[ImportedThread]
,[CreateDate]
,[EditDate]
Forum:
SELECT [ThreadID]
,[ParentID]
,[IsParent]
,[LastID]
,[ThreadCount]
,[ViewCount]
,[ForumID]
,[UserID]
,[CreateDate1]
,[EditDate2]
,[Subject]
,[Content]
,[Visible]
,[Lock]
,[SiteID]
,[SystemMsg]
,[StaticUser]
,[StaticUserEmail]
,[ImportedThread]
,[CreateDate]
,[EditDate]
FROM [akvariefisk].[dbo].[Forum_Thread]