Database Discussion - Database performance question

Print Page | Close Window

Database performance question

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=2835
Printed Date: 29 March 2026 at 12:52pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Database performance question

Posted By: Bluefrog
Subject: Database performance question
Date Posted: 19 May 2003 at 5:42am

Does anyone know how a massive number of tables affects performance in an MS SQL Server database? e.g. about 100 tables.

Thanks

Replies:

Posted By: ljamal
Date Posted: 19 May 2003 at 9:09am

The number of table really doesn't affect the database as much as the number of rows in the tables. Having 10,000 tables with 10 rows would perform faster than 1 table with 100,000 rows.

I have database with about 60 tables with 4 or 5 tables with over 50,000 records and this database performs much faster than the databas on the same server with 10 tables and six tables with over 150,000

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming

Posted By: Gary
Date Posted: 19 May 2003 at 9:39am

More importantly, the design of the database (indexes, keys, realtionships, etc) will have a massive impact on performance - especially where you have a large number of rows.

Posted By: Bluefrog
Date Posted: 19 May 2003 at 8:45pm

Thanks. That's what I was thinking, but I wasn't too sure.

The database I'm thinking of already has close to 100, but I want to add the forum (7.01) into the database (18 more tables) along with some new functionality for it.

Next question: Now if one area, e.g. the forum here, has a great number of rows in some tables, e.g. tblTopic, tblThread, tblAuthor, etc., will that adversely affect the performance of the rest of the DB? There will only be two areas in the rest of the DB that link to the forums - for the Authors portion of WWF.

I'm integrating portions of the forums with a registration process. I'd like to automatically create forum users when they register. etc. etc.

Thanks