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
jpatuto
0
Newbie Poster
Recommended Answers
Jump to PostJust 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,
-JPDB restrictions are usually affected by the system resources available …
All 2 Replies
trudge
8
Junior Poster
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.
SheSaidImaPregy
28
Veteran Poster
There are no max tables with MySQL, but that depends on your system. But there are just about 3400 max columns in a single table.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.