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)
 Optimum number of tables in a database

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-10-04 : 22:57:41
Preeti writes "Hi........
We are developing an e-commerce solution.The application is quite big and the we have reached 100 tables in the database. There may be another 50 or more tables.
Is it optimal to have so many tables?Is there any constraint on the number of tables and will the number of tables effect the performance of the system?

Hope to get a response soon.

Regards"
   

- Advertisement -