Number of tables within a SQL Database

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 456,536 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,089 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser: Programming Forums

Thread Tools Display Modes

Views: 1679 | Replies: 2

•

Join Date: Oct 2007

Posts: 2

Reputation: jpatuto is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

jpatuto

Offline

Newbie Poster

Number of tables within a SQL Database

Oct 14th, 2007

Just a question on database setup and application. If I have one database, with multiple tables within it, at what point does it become prohibitive. 50 tables? 100 tables? Is it a memory thing? How can I check?

Thanks,
-JP

•

Join Date: Sep 2007

Location: North Bay Ontario

Posts: 176

Reputation: trudge is an unknown quantity at this point

Rep Power: 2

Solved Threads: 20

trudge

Offline

Junior Poster

Re: Number of tables within a SQL Database

Oct 15th, 2007

•

Originally Posted by jpatuto

Just a question on database setup and application. If I have one database, with multiple tables within it, at what point does it become prohibitive. 50 tables? 100 tables? Is it a memory thing? How can I check?

Thanks,
-JP

DB restrictions are usually affected by the system resources available (OS, RAM, CPU, disk space). Your question can't be answered very well without knowing what kind of data are in the tables and what kinds of queries you will be executing.

And what does 'prohibitive' mean? That is very subjective.

Amer Neely - Web Mechanic
"Others make web sites. We make web sites work!"