PDA

View Full Version : Mysql tables



apwade
21 Nov 2007, 07:15 AM
Is there a major decrease in performance on the server if there are thousands of tables with a small number of records?

What is the really the max number of tables i should have in a database?

I am interested in the performance, but is using to tables to automate a process not displaying a web page using php and mysql.

Cheers

Andrew

[deleted by moderator]

sproutware
03 Dec 2007, 12:04 AM
I would say, there shouldn't be a performance gain with going with one huge table. There is a 4gb limit on the size of a table however.

Hope that helps