Web Wiz Forums - Too big a thread table?

Print Page | Close Window

Too big a thread table?

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=30629
Printed Date: 30 March 2026 at 10:07pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Too big a thread table?

Posted By: MarioM
Subject: Too big a thread table?
Date Posted: 13 January 2013 at 10:35pm

Hi
I have got a quite big forum. A tblThread table has 586 000 rows and data space is 526MB.
Is it normal data space or not?

My forum is at MSSQL2008R2.

regards, Mario

Replies:

Posted By: WebWiz-Bruce
Date Posted: 14 January 2013 at 11:14am

526MB for 586,000 posts is quite normal, if anything it is low. A database with this many posts you would usually be looking at between 600MB and 800MB.

Your forum should still perform well as have other Web Wiz Forums using SQL Server 2008 R2 that have over 5 million posts and have around 5GB SQL Server database.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: billd3
Date Posted: 14 January 2013 at 7:09pm

holy cow.
Bruce must consider our forum "SMALL" in comparison after seeing the numbers posted here.
We are at
Our users have posted 321,133 Posts in 29,523 Topics in 51 Forum(s)
and 8100 members and I thought that was pretty large compared to similar forums - car related and all.
SQL will indeed take a whole lot of use and not balk. We've got SQL at work and it will take some large databases with ease. Our security software database is in the multi-gig area and performs nicely.

-------------
BillD
http://theamcpages.com
http://theamcforum.com

Posted By: IanSmithISA
Date Posted: 15 January 2013 at 7:12am

Good morning

My forum is empty so performance is not an issue, however I noticed that the column <table prefix>thread.message is not set up with full text indexing.

Having a nose around search_process.asp, it appears to me that the topic search is implemented in the same way for all supported databases using the LIKE predicate.

I know that Access mdbs don’t have full text support, but MySQL and SQL Server do and the performance advantages are massive, especially for the larger forums.

I also appreciate that full text indexing is an optional install so it can’t be assumed to be present.

Would this be an area where it would be beneficial to have database server specific code, not only would it improve performance for the users, it would also reduce database server load?

In my office I am the only person using my development SQL Server so I can get the benefit of all of the RAM being used to cache the database that is relevant to the project that I am currently working on, so even larger tables may end up completely cached in RAM. In a shared hosting environment this is much less likely to be happening so performance will be a lot worse.

Bye

Ian

-------------
Why does anyone need more than an 80x25 character only VDU?